08 - Dashboard Designs and Assignments

Question 1

On a dashboard, how can I select the Accessories grouping and make it filter the results on the other visualisation on the same dashboard?

Answer 1

Select the visualisation and click on the filter button. This will create an action that will filter other visualisation on this dashboard.

Question 2

What happens if we select Ignore Actions for a visualisation on a dashboard?

Answer 2

It means that filters applied to other visualisations on the dashboard will not impact this particular visualisation. Effectively, filtering only works in one direction, which is from this visualisation to others.

Question 3

There are two sheets included on the dashboad below. Explain how to ensure that when I filter the one on the left by Grouping == Accessories, then one on the right will also be filtered accordingly?

Answer 3

Select the sheet on the left, the toggle on the Filter icon. This will ensure that whaetever selection is filtering its result will also filter the results on the right.

Question 4

Provided that filters are enabled for all visualisations on a dashboard, what will happen to the visualisation on the right if I filter the one on the left by Grouping == Accessories?

Answer 4

Even though the visualisation on the right does not include the Grouping dimension, it shares the same dataset as the visualisation on the left-hand side.

Since filters are all enabled, when I filter the dataset byGrouping == Accessories, then the resulting table will also apply to the visualisation on the right. In summary, visualisations do not need to share the same dimensions in order to filter each other.

Question 5

What is the difference between these 3 filters?

Answer 5

• Top filter applies to the Grouping dimension
• Middle filter applies to an aggregated measure - SUM(Sales)
• Bottom filter applies to Profit at a row level, no aggregations is involved.

Question 6

What does this symbol means?

Answer 6

This means that the filter applies to multiple worksheets, not only the current worksheet.

Question 7

Imagine that I added a filter to my dashboard that applies only to one of its composing sheets. How can I make the filter to apply to all sheets on the dashboard?

Answer 7

• Select the filter
• Go to Apply to Worksheets
• Select Select Worksheets
• Select all sheets from the dashboard

Question 8

On the dashboard shown, the worksheet containing the visualisation on the left included a filter Year of Purchase Date. How can we enable this filter also on the dashboard?

Answer 8

1. Click on the left sheet on the dashboard
2. Click on the expand/more button (arrow pointing down)
3. Go to Filter
4. Select the filter created on the original worksheet