Hi all
I m wondering if there is a way to have top 10 of a data item without using "rank" function ?
for example I want to have the 10 recent shippement for each shipper (top 10 date of shippement)
Thank you
on dimensional, I believe the function topcount can be used for that. on relational, I don't see an alternative solution.
Why rule out using rank, though?
Bar charts have a property for it, if you need it for that. Otherwise: what he(spora) said.
Hello ,
Thank you for your reply , I want to have the top 10 of reports which failed exactly 8 times during their last 8 execution , so I m using rank to have the last 8 execution by report :)
sorting on descending order to the measure column and do running-count(measure col or any col that you want) then drag this into filter running-count<=10 should get 10.
Sent from my GT-N8000 using Tapatalk