Exact differences between avg and avgOver

Q&A
1

Hello,
I do not get the points of exact differences between avg and avgOver.
I have alrady read explanations on Quicksight user guide.
Could you help me to understand these, please?

2

avg: if using this example, the avg sales of Argentina is 275.11. it sums total sales amount divided by number of rows in the data source

avgover: if you need to calculate the average sales of each country by a specific dimension instead of total row count, you need to use avgover. in this example, I am calculating the avg sales for each country. avg over sales is 3973.81. it was calculated by summation of Argentina total sales(35,764.31) divided by number of Industry(9) of Argentina
image

1 Like
3

thank you for your help. This helps me a lot.

1 Like
4

Thanks so much for letting us know @Megumi! Thanks so much for sharing your expertise to help @Megumi get a solotion @royyung! :100: :+1:

1 Like