Report showing total active records per month

[MBarrott]

Is it possible to create a line graph report that simply shows how many records (INC/SCTASK/CHG) were active over the past 3 months?

Not opened during those months, but open/active just in general. I'm not feeling a simple way to refine this down to just a 3 month period, broken up per week. 

[SAI VENKATESH]

Hi @MBarrott 

You can follow the below image to the appropriate visual representation instead of using line chart you can use In Time series "column"

Here you can check count of all types such as incident, catalog task, change created every week clearly. you need to create report on Task table

Regards,

Sai Venkatesh

[AndersBGS · Accepted solution]

Hi @MBarrott ,

No, this is not possible, as you have no fixed timestamp. To generate such a report, you need to have performance analytics installed and take snapshots of data. 

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

Best regards

Anders

[MBarrott]

Hi @AndersBGS - you're right I ended up resolving using PA. 

[shaikrahemu]

Hi @MBarrott,

I have similar requirement, can you please let me know how you achieved this, as I'm new to PA.