How to calculate monthly avergage?

Question & Answer
1

Hi there! I have a pivote table in my quicksight analyisis with orders per product.
I need to calculate the monthly average so i’ll obtain a table like this:

image
image1028×103 3.81 KB

I tried using caculated fields with windowAvg, periodToDateAvgOverTime, runningAvg, etc. It’s not working. Please help!

2

If these averages are not working you could try:

sumOver
(
measure
,[ partition_field, … ]
,calculation level
)

and then divide this by the count of how many times the value is occurring to get the same result. But actually I believe the functions are mentioning should do the same. How did you write formula? Maybe I can help.

3

Hi, @ramosm. Did @Jeroen_O’s solution work for you? I am marking his reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community Q&A Forum!