Forum Discussion

Newbie22's avatar
Newbie22
Icon for Resolver I rankResolver I
4 years ago
Solved

Create Conditional Formatting based on Target and Minimum Target

Hi Everyone,   I'd like to ask for your help. I have data with different targets per SLA. Minimum column is also target but it's the minimum % an SLA must have.   I created a measure that I...
Need Help
Tutorial Requests
  • Newbie22's avatar
    Newbie22
    4 years ago

    Thank you. 

     

    I already got the solution and It worked ðŸ˜Š

     

    Here it is:

     

    _ConditionSLATarget =
    SWITCH(
    TRUE(),
    [_SLA Summary Results] >= [Target],1,
    [_SLA Summary Results] >= [_Minimum],0,
    [_SLA Summary Results] < [_Minimum],-1)

Newbie22's avatar
Newbie22
Icon for Resolver I rankResolver I
4 years ago

Please don't hesitate to message me if you need additional information ðŸ¤—

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Newbie22 , Make sure the above is created using measure and you are creating a measure

 

like

[_SLA Summary Results] >[Average of Target]

  • Newbie22's avatar
    Newbie22
    Icon for Resolver I rankResolver I
    4 years ago

    Thank you. 

     

    I already got the solution and It worked ðŸ˜Š

     

    Here it is:

     

    _ConditionSLATarget =
    SWITCH(
    TRUE(),
    [_SLA Summary Results] >= [Target],1,
    [_SLA Summary Results] >= [_Minimum],0,
    [_SLA Summary Results] < [_Minimum],-1)