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

[pradeep_jaiswal]

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 ?

[Hyder_Ziaee · Accepted solution]

Here is how you can do it...

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

Create a calculated metric:

This is how it shows up:

[scottt6073095]

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

[Hyder_Ziaee]

Will need to test that out. nice catch.

[Hyder_Ziaee]

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.

[scottt6073095]

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

[Hyder_Ziaee]

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]

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.

[SM_AP1]

Adobe Insight (the old Visual Sciences - not sure what it is called now) had the option to limit the data shown by pretty much any metric in the table - would be nice to have that feature in AA - without having to create custom Metrics.

Just a thought

Thx

SM_AP1