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 ?
Solved! Go to 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:
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:
Is there a way for the total to match the visits >= 3000 and to remove the 0 records from the table?
Will need to test that out. nice catch.
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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.
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.
Views
Replies
Total Likes
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