Forum Discussion

ThomasPHT's avatar
ThomasPHT
Regular Visitor
6 years ago

Create Very Low. Low, Medium, High, Very High Indicators

Hello Everyone,    I try to create indicator based on quintile. ie for a specific zip code try to compare the penetration of 35 - 40 years old vs. entire population    What I did :  1. create a ...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

You can use a switch statement for that

 

SWITCH(TRUE(),Percentile.Inc(your data,0.2),"Very low",Percentile.Inc(your data,0.4),"Low",Percentile.Inc(your data,0.6),"Medium,",Percentile.Inc(your data,0.8),"High","Very high")

 

CAVEAT:  this will only show the data in the "Low" quintile that is not ALSO in the "Very low"  quintile. This may or may not be what you want.

ThomasPHT's avatar
ThomasPHT
Regular Visitor
6 years ago

Hello thank you for your help, 

 

unfortunately it doesn't work, here is the message:

Feedback Type:
Frown (Error)

Timestamp:
2020-06-18T13:52:53.3880067Z

Local Time:
2020-06-18T09:52:53.3880067-04:00

Session ID:
3875600a-d3e9-4486-9f66-9d978a9ec00c

Release:
June 2020

Product Version:
2.82.5858.641 (20.06) (x64)

Error Message:
MdxScript(Model) (38, 285) Calculation error in measure 'Sample _data'[Quintile 2 test]: Function 'SWITCH' does not support comparing values of type True/False with values of type Number. Consider using the VALUE or FORMAT function to convert one of the values.