Answer-first summary for fast verification
Answer: Create a level-aware calculation - aggregate (LAC-A) function.
Option C is CORRECT because a level-aware calculation - aggregate (LAC-A) function in Amazon QuickSight allows you to specify the aggregation level independently of the visual's dimensions. By using a LAC-A function, such as `sum({Revenue}, [{Region}])`, you can calculate the total revenue for each region regardless of the drill-down levels present in the visual. This ensures that the dashboard displays the total revenue per region consistently, irrespective of any other dimensions or hierarchies applied in the analysis.
Author: Ritesh Yadav
Ultimate access to all questions.
Question 24/58\n\nA data engineer is using Amazon QuickSight to build a dashboard to report a company's revenue in multiple AWS Regions. The data engineer wants the dashboard to display the total revenue for a Region, regardless of the drill-down levels shown in the visual.\n\nWhich solution will meet these requirements?
A
Create a table calculation.
B
Create a simple calculated field.
C
Create a level-aware calculation - aggregate (LAC-A) function.
D
Create a level-aware calculation - window (LAC-W) function.
No comments yet.