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 create an if/then calculated metric with a BETWEEN function?

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-08-2019

Hey all,

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

I created a calculated metric based on the feedback I received in a different post, which was only trying to find visits under 1,200 (see the screenshots below), but now I'm trying to do a BETWEEN 1,200 and 200.

1805726_pastedImage_1.png

1805727_pastedImage_2.png

Does anyone have an idea on how to do this?

Thanks!

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Coach
MVP
Andrey_Osadchuk
MVP

Likes

509 likes

Total Posts

917 posts

Correct Reply

243 solutions
Top badges earned
Coach
Contributor
Seeker
Bedrock
Boost 500
View profile

Avatar
Coach
MVP
Andrey_Osadchuk
MVP

Likes

509 likes

Total Posts

917 posts

Correct Reply

243 solutions
Top badges earned
Coach
Contributor
Seeker
Bedrock
Boost 500
View profile
Andrey_Osadchuk
MVP

02-08-2019

It is not possible at the moment. Your segment is looking for Visitors with 1200+ visits within the selected date range.

Vote for the metric filter idea  >> Metric Filters

Answers (4)

Answers (4)

Avatar

Avatar
Boost 50
Level 5
ashokkumarm
Level 5

Likes

85 likes

Total Posts

55 posts

Correct Reply

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

Avatar
Boost 50
Level 5
ashokkumarm
Level 5

Likes

85 likes

Total Posts

55 posts

Correct Reply

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

05-08-2019

Hi,

Unfortunately there is no option o hide zero value data.

You can write this issue in New idea section.

Regards

Ashok

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

05-08-2019

Thanks so much, Ashok!

For some reason, the stories below 1200 pageviews and above 200 pageviews are still showing up as rows --they're just blank.

Is it possible to remove these balnks rows?

Thanks again!

Avatar

Avatar
Boost 50
Level 5
ashokkumarm
Level 5

Likes

85 likes

Total Posts

55 posts

Correct Reply

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

Avatar
Boost 50
Level 5
ashokkumarm
Level 5

Likes

85 likes

Total Posts

55 posts

Correct Reply

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

05-08-2019

Hi ,

I have created a calculated metric for your requirement with Pageviews. Try this calculation you will get the result.

1807170_pastedImage_0.png

Calculated metrics have Option to check multiple conditions like above screenshot.

1807171_pastedImage_0.png

Regards

Ashok

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-08-2019

Thanks for your response! I'm not sure I understand though - I'm just looking at visits for a dimension that shows a given story's title.

Why would this calculated metric be looking for Visitors with 1200+ visits within the selected date range?