https://community.databricks.com/t5/get-started-discussions/group-by-using-a-filter-parameter-in-sql-dashboard/m-p/37908#M5467 <P>Hey all,</P><P>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.</P><P>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.</P><P>Any thoughts?</P> Tue, 18 Jul 2023 22:48:30 GMT ehpogue 2023-07-18T22:48:30Z https://community.databricks.com/t5/get-started-discussions/group-by-using-a-filter-parameter-in-sql-dashboard/m-p/37908#M5467 <P>Hey all,</P><P>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.</P><P>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.</P><P>Any thoughts?</P> Tue, 18 Jul 2023 22:48:30 GMT https://community.databricks.com/t5/get-started-discussions/group-by-using-a-filter-parameter-in-sql-dashboard/m-p/37908#M5467 ehpogue 2023-07-18T22:48:30Z