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
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

classification builder

scottt23929401
Level 2
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
Asheesh_Pandey
Correct answer by
Community Advisor
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
fsakjlfdsakljfd
Level 5
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.

Asheesh_Pandey
Correct answer by
Community Advisor
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

scottt23929401
Level 2
Level 2

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