Average in quicksight

I m truggling to calculate avg on a sum value field, can anyone give pointer

So you want each field to be a sum but the total to be an average?

Can you try this?


tred this is taking the avg of each row, it is not giving the avg of the sum like what I need is sum(avgg)/31 for month of january

Hi @tejasait!
If you are trying to get the average row value across the month, you could use the avgOver function and partition by the month of the date value. In the screenshot provided, I have daily sales and have calculated the avg daily sales by month. Does this answer your question? If not, please provide additional details.

Best Regards,

Hi @tejasait
We hope Kellie’s solution worked for you. Let us know if this is resolved. And if it is, please help the community by marking his answer as a “Solution.”