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. 

[MBarrott]

Hi @shaikrahemu, 

I would check and see what OOTB automated indicators you have in your instance. You may already have one that tracks number of open tickets and could be easily modified to fit your needs.

If not, you will need to create an automated indicator with an indicator source that captures the total # of records for your given criteria (e.g. task type is incident, change request etc). Set the frequency of this to whatever meets your requirements, for me it is daily. 

One the indicator itself you would then want to set the Aggregate to "Count". 

After your indicator and indicator source are tailored to your needs, you would create a Widget to give a visualization to that data on a dashboard.

One thing to keep in mind with the indicators is what data you will capture and how you want to breakdown and analyze the data. For example, I break my data down at the CI level but it can be broken down by nearly anything. 

This link might help with the indicators/indicator sources: https://developer.servicenow.com/dev.do#!/learn/learning-plans/xanadu/servicenow_application_develop...

Let me know if you have any questions. 

[shaikrahemu]

Hi @MBarrott,

Thank you for your reply.

My actual requirement is to get the monthly Bar graph type report of active projects(The report should show the count of active projects on month basics).

I have created a Monthly frequency Indicator and Indicator source along with Widget and attatched it to the job aswel, But I'm unable to get the report.

Sharing the screenshots for reference.

Thank you

[MBarrott]

Hi @shaikrahemu, 

What do you mean "unable to get the report"? Nothing is jumping out at the conditions for the indicator/source or widget but I would check the condition filters you may have set (would assume active is true would be one)

Is your indicator linked to a schedule data collection job?