Join the discussion
Question 11/19
A multi-national company wants to have a Tableau dashboard that will provide country-level information for both its forecast summaries and year-on-year metrics. The company wants to toggle between these two views while leaving main key performance indicators (KPIs) visible on the main dashboard.
Which method is the most efficient in achieving the company's requirements?
Which method is the most efficient in achieving the company's requirements?
Correct Answer: D
The most efficient method for toggling between two views (forecast summaries and year-on-year metrics) while keeping main KPIs visible involves using a parameter and calculated fields for controlling visibility:
* Create a Boolean Parameter: This parameter will have two aliases representing the two views ("Forecast View" and "Year-on-Year View"). This allows the user to select which view they wish to see directly from the dashboard.
* Calculated Field: Create a calculated field that always returnsTrue. This field acts as a constant placeholder to enable the visibility control tied to the parameter.
* Dashboard Setup: Place both the forecast summary and the year-on-year metrics sheets on the dashboard. Set the year-on-year metrics sheet as a floating object over the forecast summary.
* Visibility Control: Use the "Control visibility using value" option in the Layout tab for the floating year-on-year metrics view. Tie this setting to the Boolean parameter so that changing the parameter will show or hide this view without affecting the main KPIs displayed on the dashboard.
* Interactivity: Implement a "Change Parameter" dashboard action where selecting different options in the dashboard (e.g., clicking on certain parts) triggers the parameter to change, thus toggling the visible view.
ReferencesThis method leverages Tableau's dashboard interactivity features including parameters, calculated fields, and visibility settings, as recommended in Tableau's user guide on dynamic dashboard design.
* Create a Boolean Parameter: This parameter will have two aliases representing the two views ("Forecast View" and "Year-on-Year View"). This allows the user to select which view they wish to see directly from the dashboard.
* Calculated Field: Create a calculated field that always returnsTrue. This field acts as a constant placeholder to enable the visibility control tied to the parameter.
* Dashboard Setup: Place both the forecast summary and the year-on-year metrics sheets on the dashboard. Set the year-on-year metrics sheet as a floating object over the forecast summary.
* Visibility Control: Use the "Control visibility using value" option in the Layout tab for the floating year-on-year metrics view. Tie this setting to the Boolean parameter so that changing the parameter will show or hide this view without affecting the main KPIs displayed on the dashboard.
* Interactivity: Implement a "Change Parameter" dashboard action where selecting different options in the dashboard (e.g., clicking on certain parts) triggers the parameter to change, thus toggling the visible view.
ReferencesThis method leverages Tableau's dashboard interactivity features including parameters, calculated fields, and visibility settings, as recommended in Tableau's user guide on dynamic dashboard design.
Add Comments
- Other Question (19q)
- Q1. A client builds a dashboard that presents current and long-term stock measures. Currently,...
- Q2. A client has a published dashboard. They change the dashboard and then republish it. Now, ...
- Q3. A company has a data source for sales transactions. The data source has the following char...
- Q4. A client is using Tableau to visualize data by leveraging security token-based credentials...
- Q5. From the desktop, open the CC workbook. Open the City Pareto worksheet. You need to comple...
- Q6. A consultant wants to improve the performance of reports by moving calculations to the dat...
- Q7. A client is searching for ways to curate and document data in order to obtain data lineage...
- Q8. A client is working in Tableau Prep and has a field named Orderld that is compiled by coun...
- Q9. A client creates a report and publishes it to Tableau Server where each department has its...
- Q10. A client wants to provide sales users with the ability to perform the following tasks: Acc...
- Q11. A multi-national company wants to have a Tableau dashboard that will provide country-level...
- Q12. A client has many published data sources in Tableau Server. The data sources use the same ...
- Q13. A client notices that while creating calculated fields, occasionally the new fields are cr...
- Q14. A new Tableau user created a simple dashboard on Tableau Server using supply chain data. N...
- Q15. For a new report, a consultant needs to build a data model with three different tables, in...
- Q16. A client wants to flag orders that have sales higher than the regional average. Which calc...
- Q17. For a new report, a consultant needs to build a data model with three different tables, in...
- Q18. From the desktop, open the CCworkbook. Use the US PopulationEstimates data source. You nee...
- Q19. A client wants to report Saturday and Sunday regardless of the workbook's data source's lo...
