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

Exclude an hour from date filter

Accepted answer
20
Views
7
Comments
edited Apr 3, 2019 7:10AM in Reporting & Analytics for B2C Service 7 comments

Content

Hi everyone,

I'm fairly new to logical expressions which is probably why I'm struggling, but any help would be much appreciated!

We have dashboard reports that summarise our monthly KPI totals (total chats, lost chats, wait time, average handle time etc) but on occasion there are events that we want to exclude from those totals - for example, we might have an hour of completely unexpected downtime which will affect our stats.  I want to be able to exclude that hour, so have the totals show all chats except those that came between X and Y on Date, to be able to easily demonstrate the effect those events have. 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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