Forum Discussion

hejszyszky's avatar
hejszyszky
Icon for Helper II rankHelper II
4 years ago
Solved

Table conditional formatting and Goal & Realisation practices

Hi, im having a table with 3 columns. Resource name, It's result goal and its result like below.

The idea i have is to color code PR% column in order to compare faster which result has reached its goal, but i did not manage to do that. Goal is a regular column, where PR% is a measure. So based on example we have Linia 8 with goal 66 and result 75.6 so id like to have 75.6 colored green etc. Am i able to do that?

Second thing is that if i show this in time like below: 

 

I'd like to avoid replicationg Goal column each month. Is there a way? On top of that id like to have same rule as above with color coding.

Also, if you guys have any experience or better practices to show such thing please share πŸ™‚

Thanks in advance!

  • hejszyszky's avatar
    hejszyszky
    4 years ago

    Nvm, i've just substracted goal with result and then provided conditional formatting rules as above

3 Replies

    • hejszyszky's avatar
      hejszyszky
      Icon for Helper II rankHelper II

      Hey, the idea with Goal not duplicating is fine , but the idea of color coding is not based on PR% column... Because of much larger number of Lines, and diferent goals, your rules assumption wont work 😞

      • hejszyszky's avatar
        hejszyszky
        Icon for Helper II rankHelper II

        Nvm, i've just substracted goal with result and then provided conditional formatting rules as above