Dropping Measures into date sliders

Variables

Date Sliders in Chartio allow people to target specific date ranges where they can analyze specific time periods.

In this example, we will be dropping in a Date Slider into a demo chart that tracks the amount spent on various marketing fields per month.

Example chart to be edited with date slider

  1. In the dashboard sidebar, click Add Control and choose Date Slider. Drag Created Date (from the Users tab) into the Dimensions field and change the Time Bucket to Month of.

    Set up date slider by dragging Dimension into field

  2. In the Preview area, name your Date Slider. Changing the Relative date to {TODAY.SUB(3, ‘months’)} will look very similar to rolling QTD (quarter to date). Click Save Chart.

    Edit date slider settings

  3. On your dashboard, click Edit Chart Data of the chart you would like to connect to the Date Slider. Drag the date column you want to filter by (from step 1) into the Filters field. Choose between and including and from the dropdowns, select {DATE_SLIDER.START} and {DATE_SLIDER.END} as the bookends. Repeat this process for every chart you want connected to the Date Slider.

    You can also add a detail to your Date Slider. In this example, it will reveal sudden upticks in users.

    1. Click Edit Filter by hovering over the Date Slider and clicking the ellipsis. Drag User Id into the Measures field and click Run Query.

    End result with date slider


Related Variables Help Articles

See more