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

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,…

So you want each field to be a sum but the total to be an average? Can you try this? avgOver(sum({field_metric}),[{census_date}])

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.”

Average in quicksight

Q&A

tejasait January 13, 2023, 4:10pm 3

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

Average Calculation for a month

Topic		Replies	Views
Average Calculation for a month Q&A formatting , quick-sight , Business-Intelligence-Engineer	1	241	November 28, 2023
How do you calculate this on a average? Q&A admin , quick-sight , reports	5	214	December 20, 2023
How to calculate monthly avergage? Q&A quick-sight , calculations	2	1690	September 19, 2022
Can we create a sum of average for calculated fields Q&A quick-sight , calculations	2	1315	November 5, 2024
Calculate the Average of a calculated field using SUM Q&A analysis , quick-sight , Business-Intelligence-Engineer	2	46	November 12, 2024

Average in quicksight

Related topics