Creating a Difference/Comparison Metric

[duncan]

Hey @ScottP !

No problem, LAC functions are a pretty interesting in how they work. I would check out the documentation here for a detailed breakdown on sumOver:

avgOver - Amazon QuickSight

Looking at this now, might work better to nest the ifelse in the LAC function. Something like:

avgOver(ifesle({management} <> ${CalcManagement}, {advertised_rate}, 0), [{floorplan_beds}], PRE_AGG)

Level-Aware Calculations: Tips and Best Practices

[Level-Aware Calculations in Amazon QuickSight] Level-Aware Calculations (LAC) are powerful functions that allow us to perform calculations at a granularity level which is different from the granularity of our datasets and/or visuals. The sample dataset referenced by this article is a dataset of product orders placed by customers. Each order can contain multiple products and each product in an order has a unique Line Item ID. Each row of our dataset represents one line item but we want to per…