function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
RevJoelRevJoel 

Average Number of Cases Per Day

I've seen this or similar questons asked before but nobody has ever answered it so I thought I'd try. Surely @stevemo has some idea. :)

I am trying to create a report to average the number of cases that we create per day over a time period for a specific account.

I have a report grouped by day with a grand total but how do I compute an average over that timeframe? Also how would I modify that so it includes days where no cases were received (0 cases)?

Stumped!
RevJoelRevJoel
OK. Looking more into what others have done, it appears that the answer for this calculation may reside in "the power of one" field. Looking deeper...