EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB44611: A threshold does not apply to metric values that are rounded due to decimal place formatting in MicroStrategy Developer 9.x.


Stefan Zepeda

Salesforce Solutions Architect • Strategy


A threshold does not apply to metric values that are rounded due to decimal place formatting in MicroStrategy Developer 9.x.

SYMPTOM:
A threshold may be created for a metric and while it seems like the metric values should match the threshold definition, the threshold is still not applied. For instance, a threshold might be defined for 'New Metric' values greater than or equal to 0.2:
 
 

ka02R000000kY3BQAU_0EM440000002CfM.png

 
Yet the threshold is not applied to 'New Metric' values that display as 0.2:

ka02R000000kY3BQAU_0EM440000002CfF.png

CAUSE:
 
One possible cause is that the metric values are being rounded. The threshold application is not based on how the metric value is displayed, but on the full metric value. Using the example above, if the formatting for the metric values are edited to show a greater number of decimal places, the values are all shown to have been rounded up to 0.2.
 

ka02R000000kY3BQAU_0EM440000002CfI.png
ka02R000000kY3BQAU_0EM440000002CfK.png

 

ka02R000000kY3BQAU_0EM440000002CfR.png

 
ACTION:
 
In order to set a threshold for all metric values that will display as 0.2 or higher, the threshold should be set to include all values 0.15 or higher. Note that in this case, several values are being rounded up to 0.15, so the threshold is not applied. However, if the number of metric value decimal places displayed is switched back to 1, the threshold display will not be confusing.

ka02R000000kY3BQAU_0EM440000002CfH.png

 
 
 


Comment

0 comments

Details

Knowledge Article

Published:

June 12, 2017

Last Updated:

June 12, 2017