Change color in flex table

StyLe
StyLe Member
in Charting

Hello,

 

I try to find a way to change color in flex table, just turning green to red and red to green because in this chart positive value are not a good thing

Comments

  • Cartergan
    Cartergan Contributor

    Unfortunatley, it seems as though color rules are disabled for flex tables so at the moment this is something that is out of reach. 

     

    If you find a workaround or a sutible solution I would love to know!

     

    Regards

  • ST_-Superman-_
    ST_-Superman-_ Coach

    I’m pretty sure there is a chart property that allows you to indicate which direction should be green for a flex table


    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
  • StyLe
    StyLe Member

    Unfortunatelly, I did not see a lot of option for this chart, we got only 4 chart properties. 

  • Godiepi
    Godiepi Coach

    Hi @StyLe 

     

    this workaround is very silly but I think it works ?

     

    can you create a beastmode to reverse the percentage so that the positive change becomes negative ?

    just multiply your value times (-1)

    `Your Value` * (-1)

    see screenshot below

    Screen Shot 06-21-19 at 11.49 AM.PNG

     

    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'
  • ST_-Superman-_
    ST_-Superman-_ Coach

    @StyLe - You are correct.  I was thinking about the properties for the Comparative Guage card. 

    1.png

     

     

    That will teach me to try to answer dojo questions from my phone ?

     

    However, I think this is a very good feature request that should be added to the flex table.  You should add it to the Ideas exchange.  

     

    In the meantime, I would recommend using the workaround provided by @Godiepi 


    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
  • StyLe
    StyLe Member

    Hello,

     

    Yes, I did it when I saw I can't play with the color the way I want. But this trick drive to reversal of the graph and negative figures that create too much misunderstanding on the result...

     

    Thank you,

     

    Philippe.

  • ST_-Superman-_
    ST_-Superman-_ Coach

    Could you split the visuals up then?  Maybe show two flex tables next to eachother, with one showing the graph and the other showing the change indicators?  (the later using the (-1)*`value` solution proposed earlier)

     

    Otherwise, display the graph with an actual bar or line chart and then show the modified flex table below but just hide the graph portion of it.


    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
  • StyLe
    StyLe Member

    That's a good idea to solve the graph part but I will still have negative value that will lead to misunderstanding in the result.

    You gave the solution in your previous I guess when you speak about adding this subject to the ideas exchange.

    Thank you,

    Philippe.

This discussion has been closed.

Categories