Adding an action filter

Let’s finish the dashboard by adding another worksheet to it. We will then apply the action filter to both the worksheets in the dashboard:

1. Create a new worksheet by clicking on the New Worksheet tab in the bottom of the workbook.
2. Make sure Internet_satisfaction is selected as the data source.
3. Drag and drop Satisfaction stability from Measures into the Columns shelf.
4. Hover over the Satisfaction stability pill so that a small arrow appears on it and click on it.
5. Navigate to Measure (Sum), and in the drop-down menu, select Average.
6. Drag and drop Region from Dimensions into the Rows shelf.
7. Drag and drop Satisfaction speed from Measures into the Rows shelf, to the right of the Region pill.
8. Hover over the Satisfaction speed pill so that a small arrow appears on it and click on it.
9. Navigate to Measure (Sum), and in the drop-down menu, select Average.
10. In the Marks card, change the mark type to Circle using the drop-down menu.
11. Drag and drop Main provider from Dimensions to Color in the Marks card.

12. Click on Dashboard, and drag and drop Sheet 2 into the dashboard view, under the Image object.
13. Increase the height of the Sheet 2 chart while decreasing the Image object by hovering over the Sheet 2 chart top border, holding it with your mouse, and moving it up.
14. In the dashboard view, click on the Sheet 1 chart and then click on the white pointing arrow (More Options) that appears alongside the chart area.
15. Select Use as Filter:

16. Try it out by choosing different parameter values from the Region or Settlement type drop-down menu and selecting and deselecting different regions in the Sheet 1 visualization.