Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Coffee Break: Join us on Wednesday, April 5th at 10am PT to chat with Ben Gaines, Director of Product Management for Adobe Analytics. Ben will be online to answer your Analytics and Adobe Summit questions.
SOLVED

How do I limit the number of results in a table?

Avatar

Level 1

I'm working with a freeform table that has the number of visits and average view time of pages from a segment our site. I want to know the pages that have the longest average view time for only the top 25 most visited articles. How do I limit the number of results based on one of the metrics and then sort by a different metric?
Thanks

1 Accepted Solution

Avatar

Correct answer by
Level 4

You can use an if statement and the percentile function to do something like 'if pageviews > 99th percentile, then average view time, else 0'.  Then if you sort the table by view time, it will effectively only sort those above the 99% criteria, everything is will be zero.

2 Replies

Avatar

Level 1

I found a way to do this by downloading a Report. I created a pages report with the average view time and visits metrics. I set the report to order by visits and set the "show" value to 25, then downloaded the report as an Excel file. In Excel, I ordered the results by average view time.

Wish there were a way to do this solely in Adobe Analytics, but this worked fine.

Avatar

Correct answer by
Level 4

You can use an if statement and the percentile function to do something like 'if pageviews > 99th percentile, then average view time, else 0'.  Then if you sort the table by view time, it will effectively only sort those above the 99% criteria, everything is will be zero.