![]() From the dropdown, choose the parameter you created to control zone visibility.Check the box for Control visibility using value.Click the Sales by Sub-Category zone, and then click the Layout tab.From the upper right corner, click the dropdown arrow and select Use as Filter. Drag the Sales by Sub-Category worksheet onto your dashboard.The Source Field is the calculation you created. The Target Parameter is the parameter you created. The source sheet is set to use the dashboard you created and the Category Sales sheet. This example uses the following Change Parameter action: Then, from the Worksheet menu on your dashboard, create a parameter action. From your dashboard, click the Sales by Category zone (dashboard object).In our example, we want Sales by Category to be visible. Drag the sheet that you always want to be visible onto your dashboard.On the Sales by Category sheet, drag the calculation that you created to Details on the marks card.This example uses the following calculation: True From the Sales by Category sheet, create a calculated field.In this example, the parameter Data type must be set to Boolean. From the Sales by Category sheet, create a parameter.For the calculation to be used as the source field for the parameter action, the calculation must be added to the marks card. This example relies on a boolean calculated field, which is used as the source field for a parameter action. By using Dynamic Zone Visibility, the second sheet is visible only after a mark is clicked in the Sales by Category zone. The following example has two sheets that use Superstore data: the first sheet has a bar chart with Sales by Category, and the second sheet has a bar chart with Sales by Sub-Category. Independent of the viz, meaning the field returns a constant value independent of the structure of the viz, such as a fixed level of detail (LOD) calculation.To be used for Dynamic Zone Visibility, a field or parameter must be: This is ideal for complex dashboards because it allows you to choose when deeper levels of data are revealed. For example, when a user clicks a mark on a viz, a previously hidden zone appears. For example, you might want to show different user groups different zones when they visit your dashboard.Īnd you can use Dynamic Zone Visibility with Parameter Actions. This is ideal for dashboards that are used by different user groups. While you can show or hide objects by clicking a button on a dashboard, Dynamic Zone Visibility allows you to show and hide objects automatically. The result is a dynamic dashboard that doesn’t compromise your desired layout. As you interact, zones on your dashboard appear or disappear. With Dynamic Zone Visibility, you can hide or reveal zones (tiled or floating dashboard elements) based on the value of a field or parameter. ![]() Dashboard space is valuable, especially when you want to progressively reveal insights about data.
0 Comments
Leave a Reply. |