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

[Iamahmad]

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! 

[PratheepArunRaj · Accepted solution]

Dear Iamahmad,

Use the function "Approximate Count Distinct".

Pages Count.

Pages Count / Visit.

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

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

[Iamahmad]

Thank you, @PratheepArunRaj! 

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