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:

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.

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!