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

How do I filter by values in Workspace?

Avatar

Avatar
Validate 1
Level 2
andyb29407885
Level 2

Likes

5 likes

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
andyb29407885
Level 2

Likes

5 likes

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile
andyb29407885
Level 2

02-07-2019

Hey all,

I'm trying to figure out how to filter out all rows with visits under 1,200. I work in news media and I'm only looking for stories that saw under 1,200 visits.

I tried to create a segment to exclude values under 1,200, but the logic just doesn't work out.

Is there any way I can filter by values?

Thanks!

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Boost 50
Level 4
Balaji_V
Level 4

Likes

75 likes

Total Posts

70 posts

Correct Reply

10 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Boost 50
Level 4
Balaji_V
Level 4

Likes

75 likes

Total Posts

70 posts

Correct Reply

10 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 10
View profile
Balaji_V
Level 4

02-07-2019

Hi Andy,

Can be done in Calculated metrics using logical function

1784592_pastedImage_1.png

1784593_pastedImage_0.png

The result of the Calculated Metrics will list out the visits which have less than 1,200 visits.

Thanks,

Balaji

Answers (3)

Answers (3)

Avatar

Avatar
Affirm 250
Moderator
PratheepArunRaj
Moderator

Likes

291 likes

Total Posts

819 posts

Correct Reply

250 solutions
Top badges earned
Affirm 250
Contributor
Springboard
Shape 1
Validate 10
View profile

Avatar
Affirm 250
Moderator
PratheepArunRaj
Moderator

Likes

291 likes

Total Posts

819 posts

Correct Reply

250 solutions
Top badges earned
Affirm 250
Contributor
Springboard
Shape 1
Validate 10
View profile
PratheepArunRaj
Moderator

04-07-2019

Dear Andy,

Agree with Bala. Creating Visits > 1200 Segment with Hit or Visit container wont work because Hit is smaller container than Visit and Visit cannot be more than 1200 in a Visit i.e. Always 1. So it will work only for Visitor Container where there are less chances that a visitor would have more than 1200 visits in your selected period and tougher to apply it for dimensions.

So you need to create a calculated metrics like above and use the calculated metrics against the dimension you need to apply. This will eliminate all the visits lesser than 1200 (Because Visits < 1200 will become 0). A trick to use!

Thank You!

Arun

Avatar

Avatar
Validate 1
Level 2
andyb29407885
Level 2

Likes

5 likes

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
andyb29407885
Level 2

Likes

5 likes

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile
andyb29407885
Level 2

29-07-2019

Hey Balaji,

Wondering if you can help me develop this calculated metric even further - I'm trying to figure out how to filter out all rows with visits under 1,200 AND visits above 300 visits. I'm trying to write a nested if/then with both functions, but just can't figure it out.

Thanks!

Avatar

Avatar
Validate 1
Level 2
andyb29407885
Level 2

Likes

5 likes

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
andyb29407885
Level 2

Likes

5 likes

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile
andyb29407885
Level 2

15-07-2019

Brilliant! Thanks so much, Balaji!