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

Posted over 6 years ago by Smarten - Support

Post a topic

Answered

Smarten - Support 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 - Support 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 - Support 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