expression

[smilingjohn]

Hi All ,

Epression :

=Chr(39) &

Concat

(

  If

  (

  $(Dashboard_Leads_DistrictRankings_Rank) > $(Dashboard_Leads_DistrictRankings_RowNo),

  Chr(11) & District_Hierarchy_Name

  ),

  Chr(39) & ',' & Chr(39),

  $(Dashboard_Leads_DistrictRankings_Rank)

) & Chr(39)

I want to show bottom 5 ranking , but the above expression is giving me bottom 7 rankings.

Can any one suggest me how do i reduce it to bottom 5 rankings .is there any way that i use to show only 5 bottom rankings by adding or making some change to the above expression ?

Thanks in Advance

[lironbaram]

hi

not sure what exactly you look for in the expression

but usually when i need to find the bottom entities

i use this approach

ranking according to the negative value

for example Concat(aggr(if(rank(-Sum(value))<=5,date),date),',')

this brings back the bottom 5 date according to sum(value)

[Anil_Babu_Samineni]

Would you elaborate more on variables? How you are indicating for Variables?

As Liron said, You can work on it. I don't think whether you can achieve this or not from your expression. Can you tell me where you are trying this?

[smilingjohn]

iam trying this on bar chart ,

[Anil_Babu_Samineni]

Is it possible to share the application?

Or try a luck from Dimension Limits -- Check the Check box and use 5 values from Smallest.

Or at last show me your image of your bar object whether how you are receiving using that Expression to UI?

[smilingjohn]

Thanks Anil ,

Actaully that expression works perfectly for other brand and gives me top 5 and bottom ranking of the subcategroy within the product category..and i have written only bottom 5 expression on this community , but this bottom 5 ranking is showing 7 subcategory for the new product , with double entries , as shown in the image ...  If you see in the image the the bottom 5 is from EAA to EA1 ...

[Anil_Babu_Samineni]

But, You have subcategory with different names. So that, It won't and try to remove the dimension and use sample Dimension and then see. How it comes

Would you able to provide sample, Please?

[smilingjohn]

In dimesion iam using value list