Performance Analytics - Unsure if Indicator Source is Correct?

[dwilcher]

Hello all,

I'm very new to PA, so my apologies if this is an ignorant question. I am trying to add a Score widget to my dashboard showing the number of Open Change records each day.

Behind this score widget I have an Automated Indicator "Number of Open Changes" (from the PA Premium - Change Content Pack). There is no additional filter on the Automated Indicator.

The Indicator is set to show up on Scorecard, and I can open the scorecard and see there are records since 2016-01-01.

I have two jobs. An inactive historical job (set to pull data from to 2016-01-01 to 2017-09-20) and an Active daily job.

However, when I view the records on the the score card attached to this Indicator I see tons of Change records that are in a Closed state and an Active = FALSE (many of them were closed 6+ months ago).   I don't understand why this is happening as this Indicator is part of the PA Premium Change Content pack. My understanding (and what I want to see on this indicator) is the Change records that are in an Open (i.e. Active) state for each day.

When I view the Indicator Source (Changes.Open, created by admin), this is what I see:

Since this is an OOB indicator I didn't want to go changing it, but I'm not sure if it's right since on the "Number of Open Changes" indicator I'm getting closed, inactive records. I compared it to the Incident.Open indicator source and it appears the filter is very similar.

Help?

[athm]

Hi David,

When you run the historical job, lets say time period to collect the data is from 01-01-2017 to today 09-20-201.

The job collects the information for each day for the time period specified in the data collector with the above condition in the indicator source,

Consider the below example :

Lets say the indicator job is now running and is at a point that it is now collecting the information for a particular day 09-01-2017.

Condition 1 : Opened on today or Opened after today = All the change requests that are opened on or before 09-01-2017. Lets say these are X number of change requests.

Condition 2: Closed is empty or Closed after today = Out of those X number of changes,

                                      those which are not yet closed till today 09-20-2017,+ those which are closed in between 09-01-2017 and today.

Lets say these are some Y number of change requests. These Y number of change requests is what you are seeing today(in which some of them are closed in between 09-01-2017 and today) + any of the change requests that are not yet closed and created on or after 09-01-2017.

Hope this helps.

[dwilcher]

Hi Anudeep,

Thanks so much for your detailed response - greatly appreciated! I think I'm understanding what you're saying, but let me write out what I think you're saying just to be sure:

When I have a filter on an Indicator source that says something like "Opened on Today or Opened Before Today AND Closed is Empty or Closed after Today"   and I run a historic data collection job from 2017-09-01 to 2017-09-10, then PA will do the following:

2017-09-01: All records Opened on or before 2017-09-01 AND were closed after 2017-09-01
2017-09-02: All records Opened on or before 2017-09-02 AND were closed after 2017-09-02
2017-09-03: All records Opened on or before 2017-09-03 AND were closed after 2017-09-03
<...continuing until 2017-09-10...>

So, with this in mind, I have an indicator source called "Changes.Open". For this indicator source, I want it to collect only the Open change records for each day. In order to do this, it sounds like my Indicator Source filter will need to be:

Opened on Today OR Opened before Today

AND
Closed is Empty OR Closed after Today
AND
Active is True

If I'm understanding you right, that would ensure that I am only getting Change records that are open each day?

[athm · Accepted solution]

Hi David,

By adding the active is true condition, the job will calculate as below,

Count those change requests that are :

Opened on or before the date of collection and "those which are closed at a later date"or not yet closed.

And change requests that are active NOW. (This additional condition would exclude the above highlighted condition closed at a later date!! ).

Meaning, this would exclude those change requests that are closed later than the collection date, because they are not active NOW.

(The active field is not tied to a date of the date of data collection).

Hope this helps David.

[dwilcher]

Yes! Makes sense!   Thank you, Anudeep!