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

Avatar

Avatar

pradeep_jaiswal

Avatar

pradeep_jaiswal

pradeep_jaiswal

04-07-2017

I have a table(page url and visit count) in worspace. how to display only those page url which have visit count more than 10k ?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

hyderziaee

Employee

Avatar

hyderziaee

Employee

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)

Avatar

Avatar

hyderziaee

Employee

Avatar

hyderziaee

Employee

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.

Avatar

Avatar

scottt6073095

Avatar

scottt6073095

scottt6073095

06-07-2017

Is there a way for the total to match the visits >= 3000 and to remove the 0 records from the table?

1244613_pastedImage_0.png

Avatar

Avatar

pradeep_jaiswal

Avatar

pradeep_jaiswal

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.

Avatar

Avatar

scottt6073095

Avatar

scottt6073095

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

Avatar

Avatar

hyderziaee

Employee

Avatar

hyderziaee

Employee

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.

Avatar

Avatar

hyderziaee

Employee

Avatar

hyderziaee

Employee

hyderziaee
Employee

06-07-2017

Will need to test that out. nice catch.