Changing date grouping on the fly using the Date Bucket filter

Chartio's Date Bucket dashboard filter allows you to change the date grouping for one or more charts from the dashboard view.

First, we'll want to add a Date Bucket filter to our dashboard. From the sidebar menu, choose Add Control > 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're going to chart Payments by date. We drag Amount into the Measures field and select Total sum as the aggregation. Then, we'll drag Payment Date into the Dimensions field. We'll click the column to open its settings, and choose "DATE_BUCKET of Payment Date" from the Time Bucket dropdown.

We'll click Run Query, select a bar chart as the chart type, and click Save Chart.

From our dashboard, we can now select any Date Bucket from the dropdown and our chart dates will be grouped accordingly.