function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Prasanth SrinivasanPrasanth Srinivasan 

formula to calculate avg number of cases recieved per hour

Hi Folks,

I have to calculate  the formula average number of cases recieved per hour? is there anyone could help me.

Thanks
pconpcon
This is something that is too advanced to do via a formula.  You may be able to do this with a report, but it might be tricky.  If you just want to see average created over all days and just broken down by hour, you will need to create a formula for Created Hour of
  
VALUE( MID( TEXT( CreatedDate ), 12, 2 ) )

Then you will need to figure out what your other facet for average is.  Then create a report that sums / averages based on these fields.
Adam CoppinAdam Coppin
For me, the question of capability has to go hand in hand with the question of where you're planning on displaying this information...  , but your best bet is probably through the reporting interface!