avgOver() with 4 arguments in webinar

Question & Answer
1

image

In the demo the avgOver( Sales , [Product, Country], PRE_AGG, [Country]), seems to use 4 arguments :

Sales = Measure
Product, Country = Partition Field
PRE_AGG = calculation level

What is [Country]? Is that the sort?

Docs seem only to mention 3 arguments : avgOver - Amazon QuickSight

2

Hi @BFJonk ,

It’s a nested calculation , your are missing closing parenthesis after PRE_AGG.

1st calculation : avgOver
2nd calculation : sum . [Country is here the partition ]

sum(
    avgOver(Sales,[Product,Country],PRE_AGG)
    ,[Country]
)

Regards,
Koushik