LAC-A is not available in nested aggregates

Question & Answer
1

I created a calculation field with nested aggregate using LAC-A.
But I have an error when saving.

We encountered an error trying to save your calculated field. Please try creating it again.

Is LAC-A not available in nested aggregates?

image
image1497×832 41 KB

2

Hi,

Yes currently there are limitations on nested aggregations , details are noted in the documentation : Using level-aware calculations in Amazon QuickSight - Amazon QuickSight

Can you explain regarding the calculation you want for PI : eg item x = (250/2500)*1000 ? or ( 250/1000)*1000

Regards,
Koushik

3

Hi, Koushik,

Thank you for your response.

Can you explain regarding the calculation you want for PI : eg item x = (250/2500)*1000 ? or ( 250/1000)*1000

I want to calculate PI is as following.
Because Item X is purchased at both stores A and B.

item x = (250/2500)*1000

Regards,
Oshida

4

Hi Oshida,

Is the following output what you are expecting ? :

Screenshot 2022-07-20 at 17.17.27
Screenshot 2022-07-20 at 17.17.27963×170 14 KB

Regards,
Koushik

5

Hi Koushik,

Yes is it.
In addition to this, I’d like to dynamically filter by the store, product etc. .

Regards,
Oshida

6

Hi Oshida,

I am not sure if you have seen the following workshop : Workshop Studio
It does guide you in implementing filters in a dashboard.

In the screenshot i posted , the PI calculation was

(sum({num_sales})/sum({num_customers}))*1000

Kind Regards,
Koushik