display the top 3 of a table in focus of some fields

[Anonymous]

Hello

I would like to display the top 3 fields from the table %entities_name according to the #tales_resolution_mois, #taux_resolution_delais and #taux_reparation_interne_mois.

what should I do please?

Thank you for your responses.

[olivierrobin]

hello

you can use limits on dimensional limits tab

[YoussefBelloum]

Hi,

if you want the same table as the image attached above but only with top 3 entities depending on what you described above, you can try this on every expression of your table (use entities name as dimension):

=if(rank(sum(taux_resolution_mois)+sum(taux_resolution_delaits)+sum(taux_reparation_interne_mois))<=3,

your_expression

)

[Anonymous]

This is what I have, how do I write?

And my expression for this field  is : =if(Num(Avg(#taux_realisation_maintenances_mois)/100,'##.00 %')<=0,0,Num(Avg(#taux_realisation_maintenances_mois)/100,'##.00 %'))

[YoussefBelloum · Accepted solution]

if your expression is this:

=if(Num(Avg(#taux_realisation_maintenances_mois)/100,'##.00 %')<=0,0,Num(Avg(#taux_realisation_maintenances_mois)/100,'##.00 %'))

try this to be able to filter on top 3 values:

=if(Rank(

if(Num(Avg(#taux_realisation_maintenances_mois)/100,'##.00 %')<=0,0,Num(Avg(#taux_realisation_maintenances_mois)/100,'##.00 %'))

)<=3,

if(Num(Avg(#taux_realisation_maintenances_mois)/100,'##.00 %')<=0,0,Num(Avg(#taux_realisation_maintenances_mois)/100,'##.00 %'))

)

PS: you should apply the rank() function on every expression you have on your table

[Anonymous]

Hi Franck Wetie,

You can also try this Expression for displaying top 3

Ex:-

Firstsortedvalue(FieldName, Sales, -3)

In this based on Field name it will pic top 3 sales the same thing you can apply similar to your table.

Thanks Regards,

Ramesh.P 

[Anonymous]

that not work

[shansundar]

Dimension limits will work but you have add one additional expression which is sum of all three expression and promote it to the first and then limit the values accordingly and hide this dummy column from the presentation tab.

Hope this resolves your issue. Let me know if it is not clear.

Thanks,

Shan S

[Anonymous]

Thank you Rousself Belloum it work.

[YoussefBelloum]

you're welcome, good luck