Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

classification builder

Avatar

Level 2

I have two different types of values and I want to classify them into quartile buckets for scroll depth tracking.

value 1 = highestPercentViewed = 33 | initialPercentViewed = 33

value 2 = 33|33

the above should both be bucketed in 50% scroll depth

however I cannot do both in the same logic. is there a way to get both in the same logic?

highestPercentViewed = ([1-9]|1[0-9]|2[0-5])(?:[^0-9]|$) = up to 25%

highestPercentViewed = (2[6-9]|3[0-9]|4[0-9]|50) = up to 50%

highestPercentViewed = (5[1-9]|6[0-9]|7[0-5]) = up to 75%

highestPercentViewed = (7[6-9]|8[0-9]|9[0-9]|100) = up to 100%

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

You can use following, it should match both the conditions.

((^.*\b0?[0-9]$|.+1[0-9]|.+2[0-5])) = up to 25%

((.+2[6-9])|.+3[0-9]|.+4[0-9]|.+50) = up to 50%

((.+5[1-9])|.+6[0-9]|.+7[0-5]) = up to 75%

((.+7[5-9])|.+8[0-9]|.+9[1-9]|.+100) = up to 100%

Thanks,

Asheesh

View solution in original post

3 Replies

Avatar

Level 5

Have you considered uploading a classification file instead?  I did something similar with a client in the past and it took less than 10 minutes to complete with excel.

Avatar

Correct answer by
Community Advisor

You can use following, it should match both the conditions.

((^.*\b0?[0-9]$|.+1[0-9]|.+2[0-5])) = up to 25%

((.+2[6-9])|.+3[0-9]|.+4[0-9]|.+50) = up to 50%

((.+5[1-9])|.+6[0-9]|.+7[0-5]) = up to 75%

((.+7[5-9])|.+8[0-9]|.+9[1-9]|.+100) = up to 100%

Thanks,

Asheesh

Avatar

Level 2

perfect. thanks. this will help me improve my regex skills