Martyn Houghton Posted December 13, 2017 Share Posted December 13, 2017 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 Link to comment Share on other sites More sharing options...
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
Already have an account? Sign in here.Sign In Now