Hi,
I want to create this query
select date_trunc('month', start_date) as month
from table_name;
using the notebook editor. is that possible?
I could not figure how or where to specify the postgres functions
Thanks
Hi,
I want to create this query
select date_trunc('month', start_date) as month
from table_name;
using the notebook editor. is that possible?
I could not figure how or where to specify the postgres functions
Thanks
Hi @sherryummen
Custom Expressions are Metabase functions - they are similar to some database functions, but not the same.
https://www.metabase.com/docs/latest/users-guide/expressions.html
https://github.com/metabase/metabase/issues/16870 - upvote by clicking on the first post
Thanks for the quick reply. I wonder whether we could have the feature in where the expression could be anything. then entered expression could be used as it is in the the query generated by metabase ? then perhaps you just return the error given by the server and metabase dont have to do any validation from its own side?
@sherryummen That is very unlikely. Then you should probably just use SQL all the way.