Reporting on Incidents and Requests

[EcFuhrmann]

Hello all,

I have hit a roadblock with reporting on Incidents and requets. I’d like to be able to see how many tickets were open at a specific time (e.g. first of the month) over a period of time (every month for X month).  The goal is to see how the number of open tickets/tasks looked at a point in time, over a period of time.

Anyone have luck with this reporting?

[SAI VENKATESH]

Hi @EcFuhrmann 

You can create a report based upon the condition Attached in the image. You can specify from which time to which time  and same process you can do for request table too

If you have nay questions please let me know 

Thanks and Regards

Sai Venkatesh

[EcFuhrmann]

This will produce for that time perdiod only. Can this be done to show over a longer time frame?

Example

In January there were X incidents open, Febauary had X open and show in one report? 

[SAI VENKATESH]

Hi @EcFuhrmann 

You can try the following condition, as attached in the image:

Thanks and Regards

Sai Venkatesh

[AndersBGS · Accepted solution]

Hi @EcFuhrmann ,

This require PA, as reports will update according to current moment. In the report designer you can report on specific dates listed in the record, but you can't see how many tickets that were open in a specific month. 

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

Best regards

Anders