Changing the date grouping using filters

Variables

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

  1. Add a Date Bucket filter to our dashboard. From the sidebar menu on the dashboard, choose Add Control and click Date Bucket.

    Click Add Control from the dashboard sidebar and select Date Bucket

  2. Set the Name and/or Default, if desired, and click Ok.

    Set the default value of the date bucket

  3. 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.
  4. 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.

    Change the bucket

  5. Click Run Query and choose a Bar chart as the chart type and click Save Chart above the chart preview.
  6. From the dashboard, we can now select any Date Bucket from the dropdown and the date chart will be grouped accordingly.

Related Variables Help Articles

See more