How do I limit the number of results in a table? | Community
Skip to main content
A
angelalr
New Participant
May 7, 2020
Solved

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

  • May 7, 2020
  • 2 replies
  • 4131 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by ForgotPassword4Times

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

F
ForgotPassword4TimesAccepted solution
New Participant
May 10, 2020

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.

A
angelalrAuthor
New Participant
May 8, 2020

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.

Terms & ConditionsAccessibility statement

Loading footer...