1. Advanced manipulations with Story Points
Ok, so what we have right now is information about customers broken into three different categories: day pass users, male and female. And we can play with the gender filter here to get a more specific drill-down.
What we would like to do now is add a story point to compare female and male customers on one side vs day pass users on another side.
To achieve that, we are going to leverage these two line graphs, which are already built, one representing female and male customers and the other one day pass users.
Let's first build a dashboard, name it "Female/Male customers vs Day Pass Users", and bring these sheets together. Let's set the size to automatic, then bring female and male customers here, and day pass users on the right. We can resize the visualizations if necessary by selecting one and dragging the side.
We can see two gender filters here - remember from Chapter 1 that the filters apply to the worksheet they were brought in from. We can always verify what worksheet a filter applies to or modify it by clicking on the down arrow, and then apply to worksheets.
Let's remove the gender filters, as we actually don't need those once the filtering has been applied, as well as the usertype filter, as we are focusing on customers. Let's also remove this count legend.
It would be great to have this legend appear on one of the visualizations, so let's make it float and drag it there. If we want to resize it, we should do it now, because we won't be able to do it once it's in a story point.
Now let's use the filter to focus the visualization on specific days. Currently, we can click on a day and specify "keep only" or "exclude". It's a bit cumbersome. Another way is to click on the pen that appears here to highlight the selected items. We can verify that this option is activated by checking for the line under the pen. Another way to verify is to click on the "Dashboard" menu item, and then on "Actions...". We should see "Highlight 1 (generated)". Now, if we select a day, it reflects on both visualizations, simply fading out the other days. We can select several days by pressing the control key while clicking on more days.
Let's unselect for now, and move the dashboard to our presentation. Let's add a blank story point, and drag our new dashboard. There we go. However, the dashboard in its current state is misleading. It makes it look like the peaks are closely equivalent, when they are not: the graph on the right is actually twice as high as the one of the left: 5600 here vs 2400 there.
So let's ensure that both axes are on the same scale. Let's right click on this axis, select "Edit Axis...", and instead of a "Uniform axis range for all rows or columns", we're going to go with a "Fixed" range, and set the "Fixed end" to 5600.
And now we have an accurate comparison between both.
All right, your turn!
2. Let's practice!