How to display only those record(say page url) in table which have visit count greater than x(say 1000)

Accepted Solutions (1)

Accepted Solutions (1)

hyderziaee
Employee
05-07-2017

Here is how you can do it...

(I have done it with Page, and Visits >= 3000)

Create a calculated metric:

1243739_pastedImage_1.png

This is how it shows up:

1243708_pastedImage_0.png

Answers (6)

Answers (6)

hyderziaee
Employee
06-07-2017

Yeah...that's an unfortunate thing. I wasn't able to remove them.I tried the using segments within the value_if_false part to remove the pages, but didn't work. The best that can be done is to use the setting to show zeroes as blanks.

Would help if there was a setting for not showing dimension values where the result is zero.

pradeep_jaiswal 07-07-2017

Exactly was my question "how to display only those page url which have visit count more than 10k ?" , I wanted to get ride of that row record it self from the table after using calculated function metric.

scottt6073095 06-07-2017

ok, the total makes sense since its above 3000 then it will show however anyway to get rid of zero records? I would only want to see records if they are 3000 or greater

hyderziaee
Employee
06-07-2017

thinking about this...the formula is to show the number if it is greater than 3000.

Since the total is greater than 3000, it is showing up.