4 Replies Latest reply: Jul 20, 2017 10:03 AM by Martín Caruso

Rank in Chart: KPI

Martín Caruso Jul 19, 2017 4:17 PM

Hello! Good afternoon!

I was presented with the following problem and would like to know if anyone could help me.

I have a table with the following values, which is assigned a ranking according to the amount.

Header 1	Header 2
Europe	100
Oceania	20
Africa	40
Asia	80
America	75

On my dashboard, I want you to select a continent (for example, America) in a KPI that ranks # 3.

I am using the ranking function, it shows me ok in the table but doing so in the KPI indicates the value 1.

I look forward to your cooperation.

Thank you very much!

Regards!

Re: Rank in Chart: KPI

Michael Reagan Jul 19, 2017 5:44 PM (in response to Martín Caruso)

I had to do something similar on a 'Top 100' chart, putting the rank on the axis of the bar chart. The expression is:

Aggr(Rank(Sum({<Company = >} Amount)) * Avg(1), Company)

It keeps the original ranking when you filter to a (or several) companies.

mike
Like Show 1 Like (1)

Actions
- Re: Rank in Chart: KPI
  
  Sunny Talwar Jul 19, 2017 7:14 PM (in response to Michael Reagan)
  
  I don't think multiplying by Avg(1) is needed, this should be enough in itself
  Aggr(Rank(Sum({<Company = >} Amount)), Company)
  
  Like Show 1 Like (1)
  
  Actions
  - Re: Rank in Chart: KPI
    
    Martín Caruso Jul 20, 2017 10:02 AM (in response to Sunny Talwar )
    
    Sunny, thank you very much for the help. It worked!
    
    Regards!
    
    Like Show 0 Likes (0)
    
    Actions
- Re: Rank in Chart: KPI
  
  Martín Caruso Jul 20, 2017 10:03 AM (in response to Michael Reagan)
  
  Mike, thanks for the help. I was helpful!
  
  Regards!
  
  Like Show 0 Likes (0)
  
  Actions

Go to original post