Hourly Report - X- Axis help

Adil N
Tera Expert

Hi is there anyway i can create a report that will show me Incidents opened by hour (yesterday) 

So for example 

between 00:00 - 01:00 - 2

between 01:00 - 02:00 - 7 etc.  

What i want to do is basically create a report that will show me in a bar graph incidents opened (yesterday) by hour. 

Ideally i would like it to be dynamic so the "Yesterday" can be changed to any of the previous days 

 

TIA

1 ACCEPTED SOLUTION

AndersBGS
Tera Patron
Tera Patron

Hi @Adil N ,

 

For sure... Create a time series report, trend by "created" and per "hour". Besides this, give a condition for "created at yesterday".

AndersBGS_0-1731396706816.png

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

View solution in original post

2 REPLIES 2

AndersBGS
Tera Patron
Tera Patron

Hi @Adil N ,

 

For sure... Create a time series report, trend by "created" and per "hour". Besides this, give a condition for "created at yesterday".

AndersBGS_0-1731396706816.png

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

Adil N
Tera Expert

@AndersBGS  

 

Thanks buddy!!