Hi all, I am trying to create a WoW formula using LAC functions, but receive this error - ‘Field must be aggregated for table calculations.’ Any idea how I can resolve this? Thanks!
WoW formula:
periodOverPeriodPercentDifference(sumOver(max({gms_amt_usd}, [marketplace])), parsedDate, WEEK, 1)
Hi @Reena - Welcome to AWS QuickSight community and thanks for posting the question. Can you please provide sample input and expected output so that we can replicate the issue and advise your accordingly.
Regards - Sanjeeb
1 Like
Hi @Reena
We have not heard back from you regarding your question. We would still like to help. If we do not hear back in the next 3 days, we will archive the question.
1 Like