Jump to content

Measures - Count of Outstanding Incidents


Recommended Posts

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,


Link to comment
Share on other sites

  • 2 weeks later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...