Limit the number of rows incase of tie in Ranking

[Former Member]

Hi,

I have a scenario where i am showing top 5 products based on the defects reported, but the products are allocated the same rank in case of defects reported is same or equal and in that case number of rows will be more than 5 any idea how we can limit the rows in case of ranking tie in webi ?

also can we apply dense rank at universe level on a universe level variable as defects reported is not a database field but it is a universe level variable.

Thanks,

Charu

[Former Member]

Here's a link that can help you in creating Dense Rank in Webi.

Regards

Niraj

[Former Member]

Thanks Neeraj , That article discusses Dense Rank and I have tried that but it is not working because my measure is universe level variable i.e defects reported . It is not there at database level. It is count of a database dimension , Will dense rank work in that case as it not working currently

[amitrathi239]

create one more variable on rank formula variable.

=runningcount([Rank Variable];(your dimension))

this formula create the numbers.apply filter on this where equal to 1

[Former Member]

Thanks for your reply

I did that but it creates value one everywhere , Rank formula is rank(defects qty) and Rankvar2 is Runningcount(rank);part_used) , but it is giving values one everywhere

I just want to limit the rows to five in table and in the chart too ..please see the attached pic..

Also my second question will dense rank work here if defect qty is not a database column but a universe level variable?

Thanks,

Charu

[amitrathi239]

sorry use this..

=Runningcount([rank]);[Rank])