Jump to content

Measures - Count of Outstanding Incidents


mojahidm
 Share

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

image.thumb.png.27636b690e40541431ce1a024a3d36ab.png

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:

image.png.ecd98cdcd8a31883ac1cc22a13d17fd6.png

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

kind regards,

Mojahid

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
 Share

×
×
  • Create New...