I want to create a report which currently shows me the events by hour. I want to change these to only between 22:00-08:00. Is there anyway to set in the search to only show results within those hours or specify which hours you want to see results for?
As you said you want a report that will summarize hourly events(as of now 24h) you want specific duration like 00:00 to 8:00. Suppose you have scheduled your report at 9.00 AM then you can calculate your required time duration like this earliest=-9h@h latest=-1h@h. Like the above calculation you can change the earliest and latest as per your scheduled timing.