Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need a way to exclude holidays from my weekly incident volume average

Content

I have a custom report that contains these columns :

Week start: date_group(stats.stat_date, $date_grp_param) 

Total chats: sum( stats.new_incidents )

Daily Average: sum(stats.new_incidents) / 5

 

I want to have my last column, daily average, account for when a day that week is a holiday. Any suggestions on a good way to do this that wouldn't be too much of a performance drain? 

Version

May 2016

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!