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

Two-conditional filter in Workspace

Avatar

Avatar
Boost 1
Level 1
haroldpwc
Level 1

Like

1 like

Total Posts

1 post

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
haroldpwc
Level 1

Like

1 like

Total Posts

1 post

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
haroldpwc
Level 1

13-06-2019

Hello! I am trying to get a list of all our pages that meets two requirements: has 100k+ visits AND and then sort by bounce rate.  I can't figure out how to do this in Workspace but assume it's a fairly easy thing to do? I want to avoid exporting and manually sorting the info.

Thank you,

Hal

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Shape 25
MVP
Andrey_Osadchuk
MVP

Likes

536 likes

Total Posts

968 posts

Correct Reply

263 solutions
Top badges earned
Shape 25
Bedrock
Coach
Boost 500
Affirm 250
View profile

Avatar
Shape 25
MVP
Andrey_Osadchuk
MVP

Likes

536 likes

Total Posts

968 posts

Correct Reply

263 solutions
Top badges earned
Shape 25
Bedrock
Coach
Boost 500
Affirm 250
View profile
Andrey_Osadchuk
MVP

04-07-2019

Hi haroldpwc, magnusf30000295,

The segments in Analytics are used to get a subset of Visitors/Visits/Hits, but not to filter the columns by aggregated sum of values.

The solution is to use Advanced Calculated Metrics. Unfortunately, it is not very easy and requires some setup. Have a look at the screenshots, and let me know if it helps you build what you were looking for.

1. This is how it will look once you set up the Calc metrics:

page filter by visits 1.png

2. Calc metrics:

page filter by visits 2.pngpage filter by visits 3.png

3. The column setting to hide zero values:

page filter by visits 4.png

Answers (3)

Answers (3)

Avatar

Avatar
Validate 1
Level 1
magnusf30000295
Level 1

Likes

3 likes

Total Posts

9 posts

Correct Reply

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

Avatar
Validate 1
Level 1
magnusf30000295
Level 1

Likes

3 likes

Total Posts

9 posts

Correct Reply

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

04-07-2019

Hi, Andrey,

my current "tweak" on the setup is somehow similar, but i just set the value to -1000, and sort by that column... But it could be usefull to make the variables containing that value (or zero in your case) to not show in the table at all... but thats not a feature i can fint any place (would be to supress variables with value=0).

1784706_pastedImage_0.png

Avatar

Avatar
Validate 1
Level 1
magnusf30000295
Level 1

Likes

3 likes

Total Posts

9 posts

Correct Reply

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

Avatar
Validate 1
Level 1
magnusf30000295
Level 1

Likes

3 likes

Total Posts

9 posts

Correct Reply

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

19-06-2019

have the same question, but doesnt seem to work as intended if this is the setup on the segment you was referring to?! I assume its not important if you apply this to the whole workspace or if you only drops it into the metrics column to get this to work (in theory)?! It doesnt work any way on my side at least.....

visits GE 1000.JPG

Avatar

Avatar
Affirm 100
Employee
ishans52004352
Employee

Likes

154 likes

Total Posts

324 posts

Correct Reply

104 solutions
Top badges earned
Affirm 100
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile

Avatar
Affirm 100
Employee
ishans52004352
Employee

Likes

154 likes

Total Posts

324 posts

Correct Reply

104 solutions
Top badges earned
Affirm 100
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile
ishans52004352
Employee

13-06-2019

Can you please try using a segment with Visits > 100K condition and apply it on Pages report in Workspace with Bounce Rate and Visits as the metric?