Expand my Community achievements bar.

Join us at Adobe Summit 2024 for the Coffee Break Q&A Live series, a unique opportunity to network with and learn from expert users, the Adobe product team, and Adobe partners in a small group, 30 minute AMA conversations.
SOLVED

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

Avatar

Level 3

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 ?

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

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

View solution in original post

8 Replies

Avatar

Correct answer by
Employee Advisor

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

Avatar

Level 6

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

Employee Advisor

Will need to test that out. nice catch.

Avatar

Employee Advisor

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

Level 6

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

Employee Advisor

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

Level 3

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

Level 2

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