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

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

angelalr
Level 1
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

2 Replies
angelalr
Level 1
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.

ForgotPassword4Times
Level 3
Level 3

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.