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
Shape 25
MVP
Andrey_Osadchuk
MVP

Likes

538 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

538 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

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
Establish
Level 5
ashokkumarm
Level 5

Likes

87 likes

Total Posts

56 posts

Correct reply

12 solutions
Top badges earned
Establish
Contributor
Shape 1
Give Back 10
Give Back 5
View profile

Avatar
Establish
Level 5
ashokkumarm
Level 5

Likes

87 likes

Total Posts

56 posts

Correct reply

12 solutions
Top badges earned
Establish
Contributor
Shape 1
Give Back 10
Give Back 5
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
Establish
Level 5
ashokkumarm
Level 5

Likes

87 likes

Total Posts

56 posts

Correct reply

12 solutions
Top badges earned
Establish
Contributor
Shape 1
Give Back 10
Give Back 5
View profile

Avatar
Establish
Level 5
ashokkumarm
Level 5

Likes

87 likes

Total Posts

56 posts

Correct reply

12 solutions
Top badges earned
Establish
Contributor
Shape 1
Give Back 10
Give Back 5
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?