A 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…

Question

Options

• ACreate a table calculation.
• BCreate a simple calculated field.
• CCreate a level-aware calculation - aggregate (LAC-A) function.
• DCreate a level-aware calculation - window (LAC-W) function.

• A
  7% (3)
• B
  2% (1)
• C
  77% (33)
• D
  14% (6)

Explanation

A Level-Aware Calculation - Aggregate (LAC-A) function in Amazon QuickSight computes an aggregation (e.g., SUM of revenue) at a fixed, specified dimension level (e.g., Region) regardless of how the visual is currently drilled down. This means even if a user drills into city or store level, the LAC-A still returns the total for the Region - exactly what is required. Option A (table calculation) is computed after visual aggregation and is affected by the current drill-down level. Option B (simple calculated field) is computed before aggregation and cannot maintain a fixed dimension level. Option D (LAC-W) is a window function for calculations like running totals or rank across a dimension, not for holding a fixed aggregation level.

No community discussion yet for this question.