Date Sliders are great to analyze periods of time, but what if you add a detail to your slider where you could focus on a sudden & unexpected uptick to analyze and drill into what’s going on? You can add another dimensionality to your date slider so you can 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”.
2. From there, you’re going to be prompted to set the parameters of your filter.
In this example, we will use the “Created Date” column from the “Users” table in the Chartio Demo Source. 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.
3. The date slider looks fine as it is, however from the way it looks now you can’t tell which dates you may want to explore the data with further.
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 like 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.