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:
On your dashboard, go to the right sidebar and select the Add Control option. Choose Date Slider from the list that appears.
From there, you’ll 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.
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!
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 as we do in this example, you can dig deeper into what’s going on by dragging the Date Slider 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: