Average Calculation for a month

Question & Answer
,
1

what kind of formula we can use to get the average?

(AVG)

aggregated_for_date Users Count
Jan 1, 2023 58,890
Jan 2, 2023 59,208
Jan 3, 2023 59,546
Jan 4, 2023 59,775
Jan 5, 2023 60,035
Jan 6, 2023 60,325
Jan 7, 2023 60,431
Jan 8, 2023 60,514
Jan 9, 2023 60,810
Jan 10, 2023 61,014
Jan 11, 2023 61,260
Jan 12, 2023 61,469
Jan 13, 2023 61,728
Jan 14, 2023 61,850
Jan 15, 2023 61,953
Jan 16, 2023 62,277
Jan 17, 2023 62,496
Jan 18, 2023 62,821
Jan 19, 2023 63,075
Jan 20, 2023 63,386
Jan 21, 2023 63,492
Jan 22, 2023 63,586
Jan 23, 2023 64,047
Jan 24, 2023 64,326
Jan 25, 2023 64,608
Jan 26, 2023 64,897
Jan 27, 2023 65,123
Jan 28, 2023 65,203
Jan 29, 2023 65,291
Jan 30, 2023 65,609
Jan 31, 2023 65,811
2

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.

Hope this helps.

Cheers,
Deep

1 Like