Dashboard interactivity
1. Dashboard interactivity
Welcome to the last screencast of this chapter, where we are going to finetune our dashboard’s interactivity. The first thing that I'm going to do is bring in a new filter. The way to do that is to go to the worksheet, in this case the “Starts by Day” worksheet. This visualization shows the number of bike trips by weekday, and the color represents the time block within each day. It would be nice to see the split for a specific season. To add the filter, I’ll right-click on seasons and click “Show filter”. If I now go back to the dashboard and select the visualization from that worksheet, I can bring in filters by clicking this little arrow and then under Filters selecting Seasons. As you can see, it was added here on the right. Let’s first customize the filter so it displays the Apply button and then make it floating so that I can move it over next to the other filter. There we go. So, now we have this nice section with the filter instructions and both the time block and the seasons filter next to it. As you can see, if I make selections with these filters, the only chart that is going to update is the Starts by Day visualization here on the bottom right corner. Ideally, we want all of the visualizations in this dashboard to change based on the filter selections made. The way to ensure that is by clicking this arrow, next to the filter, and under “Apply to Worksheets”, I'm going to click “Selected Worksheets”. Check all worksheets that are present in this dashboard and click OK. Then I'm going to do the exact same thing for the other filter. There we go. Now, if you change the filter, you'll see that every visualization is going to be updated. If we navigate to the individual worksheets, you’ll see that every worksheet you have selected is filtered. Even if those worksheets didn’t show the filter before. Let’s go back to the dashboard. The one thing that we haven't taken into account when doing this, is the tooltip. If you hover over Monday afternoon in the “Starts by Day” chart, it displays a tooltip value of 89,000 something. You'll see that if I filter, for example, for Summer, it's still going to be the exact same value. If I do just Winter, still the same value. So we can see on the bar chart that the value changes, but the tooltip values don’t update. So, what I should have done, instead of applying the filters to selected worksheets, is apply them to “All Using this Data Source”. That will ensure that the other sheet, which displays the Time Block counts in the tooltip, is also going to be updated. Now you’ll see that if I just select Winter the value is 12,000 something, and if I select Summer it's 44,000 something. So after doing this everything is updated as it should. This is the dashboard with full interactivity. We just made sure that the entire dashboard updates based on the filter card selections. Don't forget that you have previously added another level of interactivity. By checking the “Use as Filter” icon, selections made in the visualizations themselves will also filter the data in the dashboard. Okay over to you!2. Let's practice!
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.