Hey all,
I'm trying to build a SQL dashboard where the consumer can select a date range, but then can also select whether they want to see the results grouped by day/week/month over that timeframe. I think this is possible for a notebook dashboard by using a widget that has a drop down and then used pandas group by, but I'm not sure how this would work with a SQL dashboard.
I tried using a parameter and then a case when with to check the parameter and return the date as a date/week/month and then using group by on that, but SQL is unhappy with taking a parameter in the conditional.
Any thoughts?