How can i create a custom dimension with ranges based on a measure values

Posted over 6 years ago by Smarten - Solution Team

Post a topic

Answered

Smarten - Solution Team Admin

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

0 Votes

Smarten - Solution Team posted over 6 years ago Admin Best Answer

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.

0 Votes

1 Comments

Smarten - Solution Team posted over 6 years ago Admin Answer

You can create a custom dimension with following condition:

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

0 Votes