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, using our demo source, 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. Next, 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. You’re going to need to name your Date Slider, this in done in the Preview area, in our example, we’ll call it DATE_SLIDER. You’ll need to remember the name of your Date Slider in order to connect it to the appropriate charts on your dashboard. Next, we’re going to use Chartio’s Relative Date variables to dynamically update a date range for all charts connected to the Date Slider rather than choosing a fixed date range which is static. Changing the Relative date to {TODAY.SUB(3, ‘months’)} will look very similar to rolling QTD (quarter to date). Afterwards, click the Save Chart button located at the top of page.

    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, then choose the options that have our Date Slider name; 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