How can I create weekly trend report for incident and group by shift basis (like ..8 to 5, 5 to 3)

[MH3]

Hi All,

Can anyone tell me How I can create weekly trend report for incident table and group by shift basis like 8am to 5pm then 5pm to 3am etc.

Thank you in advance

[AndersBGS · Accepted solution]

Hi @MH3 ,

TO my best knowledge you can't do what you're requesting. Either you need to trend by week or you need to trend by created time using report ranges. As an alternative, you need a field on the form that indicates the shift. By that you can trend by week and stack by shift.

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

Best regards

Anders

[MH3]

Hi @AndersBGS ,

Thank you for the reply. It really helped.

[AndersBGS]

Hi @MH3 ,

Great to hear, any further details needed? Otherwise, please make sure to close the question/accepted as solution, so other community members can see that your question has been resolved.

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

Best regards

Anders

[shen1]

Though it is not possible to group by shift basis like 8am to 5pm then 5pm to 3am, we can group them by 0-8 hrs, 8-16hrs and 16-24hrs ticket data.

You have to create 3 data sets 1) 0-8 2) 8-16 3)16-24 based on sc_request/incident table grouped by opened column.Add filters as per your requirement and the report runs like a charm.