Community & Support Portal

I need to have a custom dimension which shows values as range levels  like:

Days is a measure which shows for each individual number of sick days leave and then it is summed over an organization.

But how to create this range dimension where the value is in a measure? Any suggestions

Organisation                                Range                                 Days

Org1                                                Less than 4 days               20

4-29                                    50

30-60                                    25   

91-180                                100

You can create a custom dimension with following condition:

ifCase( Organization=="Org1" && Days==20, "Less than 4 days", ifCase( Organization=="Org1" && Days==50, "4-29",ifCase( Organization=="Org1" && Days==25, "30-60", ifCase( Organization=="Org1" && Days==100, "91-180", ">180"))))

This is for the example mentioned in your query above. Similarly you can update the condition based on your requirements accordingly.