Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
avg(aggr(count([ID]),[Date]) ) seems to be not working. I want to get the daily average number of persons by year and month and display in a bar graph, that changes dynamically from year to month
That formula appears to be correct. What exactly is the problem you are having with it?
Load * Inline [
ID, Date, Month
1, 1, A
2, 1, A
3, 1, A
2, 2, B
5, 2, B
3, 3, B
1, 3, B
1, 3, B
];