Forum Discussion

DebbieE's avatar
DebbieE
Icon for Community Champion rankCommunity Champion
7 years ago
Solved

Create a comparison report of data from the same table

Say I have the following table   Person     Win      Loose      Draw   Plays A              3           7              0          10 B              5          8               1           14 C   ...
Need Help
  • Sansudhi8's avatar
    Sansudhi8
    7 years ago

    Hi,

     

    Please see the attached. (Use Edit Interactions) 

     

    PBI

Sansudhi8's avatar
Sansudhi8
Icon for Helper III rankHelper III
7 years ago

Hi,

 

Please see the attached. (Use Edit Interactions) 

 

PBI

  • DebbieE's avatar
    DebbieE
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Thants fantastic,

     

    Thank you very much. Ididnt realise you could do this in Desktop. Thats great

    Also I  need to figure out how to show the metric in green or red if its better or worse that the other player

    • Sansudhi8's avatar
      Sansudhi8
      Icon for Helper III rankHelper III
      7 years ago

      Hi ,

       

      See the attached file. i am not good with colors. :smileyhappy: 

       

      PBI Edited 

      • DebbieE's avatar
        DebbieE
        Icon for Community Champion rankCommunity Champion
        7 years ago

        Wow, thankyou so much,

         

        Im guessing you cant do the same thing in the tables displaying the single persons data. So If player A has been selected with 3 wins and Player B is selected with 5 Wins 3 is red and 5 is green in the seperate tables?

         

        Im guessing that would be two difficult because you are conditional formatting between two seperate tables