How to make Incident (INC) State Static to see daily

[AMIRULHAKIM]

This report runs on daily basis, is there a way we can have a breakdown of all tickets static that means the state doesn’t change for that particular day.

When the number changes, we can’t accurately track the data.

Is it possible to make the INC Ticket state static like In Queue, Assigned because for now the ticket INC is moving in real time. Hope my explanation is clear.

[Mark Manders]

There's your cause: change it to relative start and relative end 1 day ago (like other OOB daily jobs). It will collect daily and show you the values from the past. You are now collecting on today how a ticket from 200 days ago looks now, overwriting the historical data of even yesterday.

[AMIRULHAKIM]

Does that mean the state for each day will remain static and will not change? I have tried but still the INC State is moving. See my data job below:

[Mark Manders]

If you collect it today as 'in progress' and tomorrow as 'resolved', it will still show you 'in progress' for today. But your setup collects the 'in progress' of today again at the moment it's resolved, so won't show the 'in progress' anymore. It's taking snapshots at how it is at the moment of collecting.

And changing it now, won't do anything with your historical data. That data is gone. You will start collecting as of this moment.