Skip to Content
Former Member
May 01, 2018 at 04:15 PM

Exclude Top 1% records from webi report

99 Views Last edit May 02, 2018 at 11:12 AM 2 rev

Hello Friends,

Please help me on this requirement. I am having tough time to resolve.

I have a requirement where I need to Exclude Top 1% records from webi report.

First lets try on Top 1 row: We need to exclude this top 1 record and do average of days from 2nd value to till last value) on rest of the records. let me know how to achieve this with ranking or any other function. Greatly appreciated for your help.


Result after sorting and removing last record - 7 days is the top record. so average of days on rest of records is 2.1Average2.1