Backlog tracking

[tsoct]

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]

Set your relative end also to 1.

You wont see a difference right away, but after a few days you will.

This is a field that cant be collected historical, because then you always collect the current state.

Just curious: What conditions do you use in the Indicator source?

[tsoct]

I have set the Relative start to 0; the relative end to 1. Together I have attached the indicator source below.

Am I on the right track to collect the number of "Backlog is true" on daily basis?

Data collector:

Indicator Source:

[Arnoud Kooi · Accepted solution]

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.

[pratik_kumar]

Hi

Just put 0 days ago at the rekative start date in youe job (i.e. data collector).

This will will collect data of same date.

If you want more information.

Please attach screenshotof of your indicator source.

if this resolve your issue. make it as correct or let me know your query.