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, Month1, 1, A2, 1, A3, 1, A2, 2, B5, 2, B3, 3, B1, 3, B1, 3, B];