Level aware aggregation pre-Agg

[neelay]

@MaryamNajimigoshtasb

If you haven’t gone through these topics. Please ref. them; (they always end up helping me finding solution)

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…

Level aware sum / sumOver problem

@David_Wong Thanks for the explanation. sum(min(total, [{rule_name}, {event_date}, {channel_id}])) worked on the given example but didn’t work on other data. here is the sample data where it didn’t work, not sure why. Expected output ICD-10 : 93, ICD-9 : 14, FDA Code : 20 total: 127 But, What I got is 86,14,19,119 respectively. [image] The Sample Data can be found here.