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

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
Moderator

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
Moderator

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