Visokio website     Downloads     Video tutorials     KnowledgeBase  
Table View: Conditional Formatting? - Visokio Forums
Table View: Conditional Formatting?
  •     vijay_chidambaram April 30, 2012 3:38AM
    Hi - How can I change the colors and represented values (eg. in the picture below, instead of 66.67% as high, if need to set up a 10%) with conditional format in a Table View.

    image

    Thanks, Kind Regards, Vijay
    Attachments
    conditional.png 99K
  • 3 Comments
  • antonio     antonio April 30, 2012 6:02AM
    Are you trying to change the graded colour range settings?
    If you open "Settings > Colour ranges..." you can define how a graded colour scheme is mapped onto a range of values.
  •     tjbate April 30, 2012 6:46AM
    Vijay - if you want continuous shades above and below a threshold value, you can set these using:

    Data > Manage fields > {field} > Options > Value colouring

    If you want an 'alert' type display with values over a threshold value say, red, and values under it green, you need to add a 'bucketing' formula to categorise the continuous range of values as either above or below threshold, and then set the corresponding category colours using:

    Data > Manage fields > {field} > Options > Value order, colour and shapes
  •     tjbate April 30, 2012 10:42AM

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership