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?
avgOver(sum({field_metric}),[{census_date}])
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,
Kellie
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.”