How do I create an if/then calculated metric with a BETWEEN function?

[andyb29407885]

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.

Does anyone have an idea on how to do this?

Thanks!

[Andrey_Osadchuk · Accepted solution]

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

[andyb29407885]

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?

[ashokkumarm]

Hi ,

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

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

Regards

Ashok

[andyb29407885]

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!

[ashokkumarm]

Hi,

Unfortunately there is no option o hide zero value data.

You can write this issue in New idea section.

Regards

Ashok