Hi all, I am struggling heavily with a simple, custom MySQL query. I basically want to get the SUM() of some contents but can not figure out how to make the MySQL query customizable, so the dashboard can apply the "Relative Date" filter.
@larsSELECT SUM(cost) FROM my_table WHERE {{mydatefilter}} and use the sidebar to connect to a date column - but remember to read the article - specially the “gotcha” aka limitations.
@lars Okay. You are basically seeing this issue, where you would have had an option available if you were using Single Date on the dashboard filter: https://github.com/metabase/metabase/issues/5781 - upvote by clicking on the first post