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

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! 

2 Replies

Avatar

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