LAC agg function is not supported

Question & Answer
, , , ,
1

I created a calculation field with aggregate using LAC. This is working fine

ATD_ATA: dateDiff({date_departure},{date_arrival},“DD” )

ATD_ATA_Avg: avg( max({ATD_ATA}, [{OrderID}]))

How ever when I’m trying to get MoM/WoW I’m getting this error.

The Operation related to Level Aware Calculation (LAC) agg function is not supported

%diff_MoM
periodOverPeriodPercentDifference({ATD_ATA_Avg},{date_arrival},MONTH,1)

Is periodOverPeriod not available in LAC ? is there any alternative to get MoM ? How can I resolve this ?

Any suggestions on how to achieve this in QuickSight appreciated.

2

Can you try doing an avgOver instead of an LAC.

periodOverPeriodDifference(
avgOver(max({ATD_ATA}),[{OrderID}]),{date_arrival},MONTH,1)

3

Hi Max,

I’m getting this error.

image
image985×370 21.1 KB

4

You will need to reference Order ID in your visual