Event count before and after a specified time

[jboustead]

I am looking to count the number of events that occur before and after a specified time (8am) each day to give a table like for example:

Events before 8am	Events after 8am
400	50

Any help greatly appreciated?

[ITWhisperer · Accepted solution]

| stats count(eval(date_hour<8)) as "Events before 8am" count(eval(date_hour>=8)) as "Events after 8am"