I am working on a report that will take the Daily Sum and report the average daily sum per month
For example I have a module that is our Billable Records - I have a current report that shows me the billables by day based on the Sum of a specific field. I need a report that will take the Sum of that field and produce a daily average per month.
ie:
November | Daily average total billed sum: 56 hours
December | Daily average total billed sum: 62 hours
January | Daily average total billed sum: 60 hours
What I am getting right now is the average per each record put in instead of the average for the duration in the filters