# LAC agg function is not supported

**URL:** <https://community.amazonquick.com/t/lac-agg-function-is-not-supported/8674>\
**Category:** Q&A\
**Tags:** analysis, level-aware, calculations, period-over-period, quick-sight\
**Created:** [December 23, 2022, 8:56pm UTC](https://community.amazonquick.com/t/lac-agg-function-is-not-supported/8674 "2022-12-23T20:56:16Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nitya\_Goriparthi](https://avatars.discourse-cdn.com/v4/letter/n/bc79bd/32.png) [@Nitya\_Goriparthi](https://community.amazonquick.com/u/Nitya_Goriparthi)\
**Post date:** [December 23, 2022, 8:56pm UTC](https://community.amazonquick.com/t/lac-agg-function-is-not-supported/8674/1 "2022-12-23T20:56:16Z")

</div>

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 Quick Sight appreciated.

---

<div class="post-metadata">

**Author:** ![Max](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/max/32/2288_2.png) [@Max](https://community.amazonquick.com/u/Max)\
**Post date:** [December 23, 2022, 10:21pm UTC](https://community.amazonquick.com/t/lac-agg-function-is-not-supported/8674/2 "2022-12-23T22:21:39Z")

</div>

Can you try doing an avgOver instead of an LAC.

periodOverPeriodDifference(  
avgOver(max({ATD\_ATA}),[{OrderID}]),{date\_arrival},MONTH,1)

---

<div class="post-metadata">

**Author:** ![Nitya\_Goriparthi](https://avatars.discourse-cdn.com/v4/letter/n/bc79bd/32.png) [@Nitya\_Goriparthi](https://community.amazonquick.com/u/Nitya_Goriparthi)\
**Post date:** [December 23, 2022, 10:38pm UTC](https://community.amazonquick.com/t/lac-agg-function-is-not-supported/8674/3 "2022-12-23T22:38:30Z")

</div>

Hi Max,

I’m getting this error.

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/1/1cd7079226632126ed205208cb1a25443f8be33d.png)

---

<div class="post-metadata">

**Author:** ![Max](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/max/32/2288_2.png) [@Max](https://community.amazonquick.com/u/Max)\
**Post date:** [December 28, 2022, 2:57pm UTC](https://community.amazonquick.com/t/lac-agg-function-is-not-supported/8674/4 "2022-12-28T14:57:02Z")

</div>

You will need to reference Order ID in your visual

---

<div class="post-metadata">

**Author:** ![July](https://avatars.discourse-cdn.com/v4/letter/j/e8c25b/32.png) [@July](https://community.amazonquick.com/u/July)\
**Post date:** [February 23, 2024, 12:47pm UTC](https://community.amazonquick.com/t/lac-agg-function-is-not-supported/8674/5 "2024-02-23T12:47:45Z")

</div>

Hello @Max

I have same problem. I made the calculated field and I referenced the id in my visual, but I recieved the error “VISUAL\_CALC\_REFERENCE\_MISSING”

How to fix it?  
Thank you
