Rank in a KPI chart

[sgqliker]

Hi,

Is it possible to show a tied rank in a KPI chart?

Below is the same measure but one is in a table and one is in a KPI. I can't get the KPI to display the 8-14.

I have already tried to change the format in the script e.g. rank(xxx ,0,0) but I only get either 8 or 14 - depending on the formatting).

Thanks

[sunny_talwar]

What is the expression used in the chart and in the kpi object?

[sgqliker]

My expression is:

Only({$<Response_% = {"$(=GetFieldSelections([Company name]))"}>}

aggr({<Response_%>}rank(

SUM({<Response_%>}{<QuestionID_% = {'Q1'} ,[Cle2_%] = {'111'} >} [Weighting_factor_%])
/
SUM(TOTAL {<Response_%>} {<QuestionID_% = {'Q1'} ,[Cle2_%] = {'111'} >}Weighting_factor_%) ), [Response_%]))

Thanks

[sunny_talwar · Accepted solution]

Can you try this

MinString({$<Response_% = p([Company name])>} Aggr(
  Rank(Sum({<Response_%, QuestionID_% = {'Q1'} ,[Cle2_%] = {'111'}>} [Weighting_factor_%]))
, [Response_%]))

[sgqliker]

Thanks!

I still just get the lowest value in the KPI chart, but the range in the table:

[sunny_talwar]

Change Number Formatting to Measure expression

[sgqliker]

Fab! thanks very much