Daily average by month
I have a calculated field that I can currently showing by month in a bar chart.
I want to be able to show the daily average over the month by month. what formula would I need to use to do this?
1st may = 30
2nd may = 20
3rd may = 10
total by month would be: 60
average for that month would be: 20
I want to show the average for the month, monthly. but when I do that it just shows the total by month, even if I use the average keyword...
Great solution. This design pattern is very useful for semi additive numbers. I.e. sum on all dimensions except date. Then if you change the grain of the date from say daily to weekly, monthly, yearly etc you will get an appropriate average over time. I.e. Daily will be sum(total)/1, weekly will be sum(total)/7 etc.