Forum Discussion

tex628's avatar
tex628
Community Champion
8 years ago
Solved

KPI Visual

Hello, I've got a large KPI report. The report produces three sub-scores that together create a final score.   The scores range from 0-5. When a score is under 1 the value will turn red. Thi...
Need Help
  • praiselyabraham's avatar
    praiselyabraham
    8 years ago

    Hi , 

     

    As per my understanding, if any of the KPI has has a red indicator i.e. value below the tqarget, the final kpi should also be shown in red.

     

    For this i created a measure that shall verify all the other measure. In your case:

    final target = IF(OR(OR([Value1]<3,[Value2]<3) ,[Value3]<3),0,1)

     

    I used advanced cards, and used this measure in the condition field to check if the value is 0 , then show it in red. 

     

    Attaching the screenshot of it.

     

    Hope this solves your issue. 

     

    Regards.

tex628's avatar
tex628
Community Champion
8 years ago

This worked, just as you said! :)

But i have a followup question regarding the "Advance card" visual.

How does the visual know which value to look at when calculating conditions? 

 

I have 3 conditions directed towards the summary measure and 1 directed to the final target measure. But nowhere in the visual do you specify towards which value the condition should look?

 

Sorry this is messy :) Hope u understand what i dont!
 

praiselyabraham's avatar
praiselyabraham
Resolver II
8 years ago

In the case shared, that condition is calculated and flaged in a measure that was created i.e. final taget.

this measure is used in the condition field of the advaced card, so based on the value of the final target measure, the condition is verfied

 

Hope this solves your confusion.