Mismatched aggregation error with ifelse() and LAC-A when trying to calculate sum for prior year

[azhukova]

Hi, I’m trying to create a simple calculation that gives me the sum of impressions grouped by month for the prior year using an ifelse() and a LAC-A calculation but I keep getting a mismatched aggregation error. Note that the year column I’m using here is formatted as a string. So far I have:

ifelse(
{year} = toString(extract("YYYY", now())-1),
sum({impressions}, [{month}]),
NULL
)

Can someone tell me why this is giving a mismatched aggregation error?

Thank you!

[David_Wong]

Hi @azhukova,

You have to move your ifelse inside the sum. Take a look at the mismatched aggregation section at the bottom of this article:

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…

[azhukova]

Thanks so much David! This helped a ton