Expand my Community achievements bar.

Announcement: Calling all learners and mentors! Applications are now open for the Adobe Analytics 2024 Mentorship Program! Come learn from the best to prepare for an official certification in Adobe Analytics.
SOLVED

Display number of pages that account for x% of total visits

Avatar

Level 1

Hi everyone! 

 

I would like to create a calculated metrics that returns row count of pages that account for x% of total visits. It seems the only way to get something working is through percentile which doesn't always return the exact percentage I want to have. Anyone been through the same or has a way to work it out? 

 

Thank you! 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Dear Iamahmad,

Use the function "Approximate Count Distinct".

PratheepArunRaj_0-1650219437402.png

Pages Count.

PratheepArunRaj_1-1650219493617.png

Pages Count / Visit.

PratheepArunRaj_2-1650219550151.png

If you want to have selective pages in the list, apply segments.

Thank You, Pratheep Arun Raj B (Arun) | NextRow DigitalTerryn Winter Analytics

 

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

Dear Iamahmad,

Use the function "Approximate Count Distinct".

PratheepArunRaj_0-1650219437402.png

Pages Count.

PratheepArunRaj_1-1650219493617.png

Pages Count / Visit.

PratheepArunRaj_2-1650219550151.png

If you want to have selective pages in the list, apply segments.

Thank You, Pratheep Arun Raj B (Arun) | NextRow DigitalTerryn Winter Analytics

 

Avatar

Level 1

Thank you, @PratheepArunRaj

 

But I do not think your answer resolves my query...