Filtering the bottom performers

Q&A
, , ,
1

I have a condition here, I want to find out the
POS by revenue bottom three performers
The attached fig 1(left) is giving us the proper result attached fig1(right) if I disable the filter(kpi total is not equal to zero or null) I have lot of null values
My end result is I want to find bottom three performers if I ad filter like the 3rd image I get no data because it takes bottom 3, how to solve this issue?

image
image865×595 66.7 KB

2

So you want to get the bottom three performers if they are not null or zero?

I would look to do this via ranks.

rank([sum({KPI_TOTAL_REVENUE}) ASC],[{POS}])

Then filter your dataset to not have nulls or zeros. Finally filter this newly calculated field to be less than or equal to 3.

3

there is some issue I am just getting 1 as the result, not working as expected

image
image747×450 35.3 KB

4

Hi,
You need to modify your rank calculation to make it work. Don’t include pos in your calculation

image

Then apply a filter using this field to show where its less than or equal to 3.

Let us know if that works.
thanks.

5

This thing worked, Thank you