Variance color coding on the dashboard

usha.cherukuri
usha.cherukuri
in User Experience

Hi,

 

We have the dashboard consists of 3 columns

A,B and variance

Now I want to highlight the third column with same color irrespective + and - ve values (tried with conditional formatting, same color option is not available to highlight +ve and -ve values in same color- Red color).

Please suggest.

 

Thanks

Usha

 

Tagged:

Answers

  • sandeep_bk
    sandeep_bk

    Hi @usha.cherukuri,

     

    You can try something like this,

     

    con1.PNG

    con 2.PNG

     

    Hope it helps.

     

    Thanks,

    Sandeep

  • kavinkumar
    kavinkumar

    HI @usha.cherukuri,

    You can rather create a new line item (number formatted) and make the applies to none (To reduce size), then put 1 in the formula bar. Now use this line item to conditional format the 'Variance' line item.

    Variance color coding on the dashboard.PNG

     

    I hope this helps!

    Regards,

    Kavin.

  • bram.kurstjens
    bram.kurstjens

    Hi Usha,

     

    In addition to the earlier responses, if you only want to color when the variance is above a certain treshold, then you could use the ABS (absolute) function on your variance value instead of just inputting 1, e.g:

    IF ABS(Variance) > 10 THEN 1 ELSE 0

     

    or if you want the color scales, you could ofcourse simply use:
    ABS(Variance)

  • usha.cherukuri
    usha.cherukuri

    Hi  @kavinkumar,

     

    Tried with suggested solution provided, and it worked as expected.

    Thank you for timely response.

     

    Thanks,

    Usha

Categories