Chartio’s Date Bucket dashboard filter allows users to change the date grouping for one or more charts from the dashboard view.
Add a Date Bucket filter to our dashboard. From the sidebar menu on the dashboard, choose Add Control and click Date Bucket.
Set the Name and/or Default, if desired, and click Ok.
- If you have an existing chart you want to connect to your Date Bucket filter, open it. Otherwise, create a new chart on your dashboard. We’re going to create a new chart.
We want to chart Payments by Date. Drag Amount into the Measures field and make sure Total sum is selected as the aggregation. Then, drag Payment Date into the Dimensions field. Click that blue shaded region to open its settings, and select DATE_BUCKET of Payment Date from the Time Bucket dropdown.
- Click Run Query and choose a Bar chart as the chart type and click Save Chart above the chart preview.
- From the dashboard, we can now select any Date Bucket from the dropdown and the date chart will be grouped accordingly.