Expand my Community achievements bar.

Join us at Adobe Summit 2024 for the Coffee Break Q&A Live series, a unique opportunity to network with and learn from expert users, the Adobe product team, and Adobe partners in a small group, 30 minute AMA conversations.
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...