Group by "Created"

Yastafari
Giga Contributor

Hi:

 

I am trying to create a report that groups incidents by create date. Unfortunately the "Created" field is a date/time stamp and therefore unless incidents are created at exactly the same hour, minute and second, the grouping effectively groups by the incidents. 

 

How do I get it to group on just the date portion of the "Created" field.

 

Thanks in advance of any help.

2 REPLIES 2

Eoghan Sinnott
Kilo Sage
Kilo Sage

Hi, 

 

When creating the report ensure you are using one of the 'Time Series' Type reports to visualize date over time. Once you have that selected you will be able to use the 'Trend By' option to select Created and then the 'per' to Day.

AndersBGS
Tera Patron
Tera Patron

Hi @Yastafari ,

 

you can create a time series report and trend by date. This will give you the trending over date without the time.

 

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/