Adding a Measure to a Date Slider

Variables

Date Sliders are great to analyze periods of time, but what if you added a detail to your slider where you could focus on a sudden and unexpected uptick to analyze and drill into what’s going on? You can add another dimensionality to your date slider to look at trends and filter your charts accordingly.

Here’s your “how-to” guide to enhancing your date slider on a dashboard:

1. On your dashboard, go to the right sidebar and select the “Add Control” option. Choose the first option, “Date Slider”.

How to add a date slider from dashboards

2. From there, you’re going to be prompted to set the parameters of  your filter.

In this example, we’ll use the “Created Date” column from the “Users” table in the Document Company Demo Data. Let’s say we wanted to filter our charts by Created Date and allow the dashboard viewer to filter anywhere between the first two months of 2019.

Date slider example

3. The Date Slider looks fine as it is, however, with a flat line, we can’t tell where spikes may have occurred to help us narrow down which dates to select to further explore the data.

Let’s say you’re interested in seeing the trend of new users added to your organization and how that changed over time. Drag in the “User Id” column into the Measures box. Upon running the query, you will see the user count trend added to the Date Slider!

User count trend with data slider

Adding a measure to your Date Slider is a great way of adding visibility into the time period being analyzed. On your dashboard, if you see a spike in your data like we do in this example, you can dig deeper into what’s going on by dragging the Date Sslider around the uptick and looking at the data to see the details and other metrics around it.

The video below goes over creating the Date Slider with an added Measure:


Related Variables Help Articles

See more