9 Replies Latest reply on Aug 28, 2017 11:31 PM by Emanuele Marcandella

    Text Tables formatting (values vs target)

    Emanuele Marcandella

      Hello everyone,

      I'm facing difficulties on coloring cells of a table respect a variable.

       

      In Excel I did that easily just with the conditional formatting.

       

      I try to explain my issue and my data source.

      I have some categories referred to my company indicator, related to date.

      I have some targets, always related to date, that of course define my target for every category.

       

      EXAMPLE OF DATA SOURCE:

      DateShirt sold
      Target Shirt soldPants soldTarget Pants sold
      31/07/20171588150014201500
      07/08/20171588155014251550
      14/08/20171615160015801600
      21/08/20171655165016881650
      28/08/20171656170019501700
      04/09/201717501750

       

      EXAMPLE OF OUTPUT:

      Colored in Green if it's <= target

      DateShirt sold
      Pants sold
      31/07/201715881420
      07/08/201715881425
      14/08/201716151580
      21/08/201716551688
      28/08/201716561950

       

      The only way I found is to create a single row (in this case column) and then use together in the same dashboard but I hope that there will be an easier way.

       

      Thanks in advance.

      Regards