Measures - Count of Outstanding Incidents

[mojahidm]

Hi Team,

Would you be able to advise me if it is possible to create a measure for incidents that were logged in a particular month and not completed by the end of the month (i.e. outstanding incidents)?

I've been able to create one by having the 'Query where clause' check to see if h_dateresolved IS NULL

But i would imagine that it will pull through cancelled requests and that the next month the h_dateresolved would have an entry in it. Which would mean that if we ever had to resample the data for any reason, the stats would no longer be correct

Currently displays as expected:

But if Sandbox 1c is ever resampled, we'd loose the data :-(

kind regards,

Mojahid

[Victor]

@mojahidm unfortunately, yes, resampling data for 1c means previous data is lost. There is no way around it I'm afraid...