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
BedrockMission!

Learn More

View all

Sign in to view all badges

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

Avatar

Avatar
Level 1
angelalr
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
angelalr
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
View profile
angelalr
Level 1

06-05-2020

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Avatar

Avatar
Shape 1
Level 2
ForgotPassword4Times
Level 2

Likes

9 likes

Total Posts

54 posts

Correct Reply

6 solutions
Top badges earned
Shape 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile

Avatar
Shape 1
Level 2
ForgotPassword4Times
Level 2

Likes

9 likes

Total Posts

54 posts

Correct Reply

6 solutions
Top badges earned
Shape 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile
ForgotPassword4Times
Level 2

10-05-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.

Avatar

Avatar
Level 1
angelalr
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
angelalr
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
View profile
angelalr
Level 1

08-05-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.