Backlog tracking

tsoct · ‎08-09-2017

We have a custom field in the incident table to flag if the incident a backlog ticket.

To track the number of backlog ticket, we have created an indicator to track the number of Backlogs is True at the end of every day (23:59:59)

Issue:

Whenever the data collected by scheduled job, the data of the previous date will be refreshed as well.

Ex: the number of backlog on 8th Aug is following the same as 9th Aug.

How can I avoid the previous data being refreshed?

The indicator:

The scheduled data collection

Arnoud Kooi · ‎08-10-2017

Set start and end both to 1, that way you only collect for yesterday, just as all OOB daily jobs.

In your Indicator you only need Backlog is true as ADDITIONAL condictions, because the other conditions are all ready set in your Indicator source.

View solution in original post

Tara Romero · ‎08-09-2017

Hi,

Technically if you just use your date logic in your indicator source and remove the backlog flag (since this is changing data) then you should be able to run historic collections or daily collections and it will capture what was open on that date by just using the date fields.

Your indicator just needs to be count and the other logic should be moved to your source.

Cheers

Tara