How to show highest total as KPI?

[#1]

Hi,

I have Students as dimension and their marks total as expression.

Dimension: Students

expression: Sum(Marks)

I would need to show the KPI of which student has highest total. Please let me know is this possible?

I used below. Is this correct expression?

If(Total>0,'qmem://<bundled>/BuiltIn/led_g.png','qmem://<bundled>/BuiltIn/led_r.png')

[MK_QSL]

Please upload your sample file ...

[#3]

Please find attached.

[MK_QSL · Accepted solution]

Change your KPI expressions as below..

If(Rank(Aggr(SUM(Marks),Student))= 1,'qmem://<bundled>/BuiltIn/led_g.png','qmem://<bundled>/BuiltIn/led_r.png')

[#5]

Hi Amelia

To return the maximum total marks by student, within the table you could use the expression

max(total aggr(sum(Marks),Student))

I've wrapped the sum(Marks) in an Aggr function by student, using the total to work it out across the whole table.

Putting this expression in an if statement and comparing with their marks would enable you to mark out the student with the greatest mark:

if( max(total aggr(sum(Marks),Student))  = sum(Marks),'Highest Student','Not highest student')

Erica

[#6]

Hi Amelia,

here is my Suggestion for your expression:

if(Rank(Sum(Marks)) = 1 ,'qmem://<bundled>/BuiltIn/led_g.png','qmem://<bundled>/BuiltIn/led_r.png')

Regards

Roland

[#7]

Thanks and that's right.