Exclude an hour from date filter

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.