Jump to content
Martyn Houghton

Percentage Measures - differentiate between actual zero and zero records

Recommended Posts

At the moment when you undertake percentage measure, it is not able to differentiate between actual zero (i.e. you failed all the to meet the resolution SLA for all the records) and zero records (i.e. no requests for the measure were found).

Would it be possible for the measure to capture the difference between the actual zero value and the no records found, perhaps storing a Null value instead of a zero, then displaying it as a non-coloured '0' on the scorecard rather than a red one?

The other alternative is having the option to reverse the percentage calculation, in that your measure selection calculates the opposite, i.e. the percentage of records you failed the condition, then take the calculated value away from 100 (%) in the second phase of the calculation before storing the measure. value. That way when you have no failure percentage or no requests found the zero is taken away from 100% leaving 100%.

The latter has the advantage that you do not need to alter the storage or display processes for the measure, just an option flag and different calculation method.

Cheers

Martyn

Share this post


Link to post
Share on other sites

Hi Martyn,

apologies for the delay getting back to you on this. So can i just clarify what the problem is:-
 

Say you have a measure called Changes That Met SLA so something like:-

% of calls where SLAMET=1 and class='change'

If there are no actual records (there are no records of class 'change')  the stored sample is 0. (but in real terms there is nothing to worry about as there were no actual records)
If there were 50 change records and all of them had SLAMET=0 the stored sample is 0. (in real terms there is cause for concern)

So the problem is you can't tell if its 0% for real or 0% because there were no change records. The measure can then be misleading because your servicedesk manager thinks wow we have missed all our change slas when in fact you don't have any changes logged in the system.

Is that the issue?

Cheers

Share this post


Link to post
Share on other sites

@Martyn Houghton i have asked the server team for some feedback on fixing this. I did provide a solution to the problem when this was first raised so they can just can implement it (if they are happy with it). I will get a firm response next week. Cheers

Share this post


Link to post
Share on other sites

Hi @Martyn Houghton,

I have just asked them for an update. Will let you know.

Cheers

Share this post


Link to post
Share on other sites

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...