Average Calculation for a month

[Deep]

Hello Daniel,

I guess you could use avgOver function.

May be this old post can be handy in your case - please check if it helps.

Average in quicksight

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

Hope this helps.

Cheers,
Deep