3 Replies Latest reply on Jan 4, 2018 7:56 PM by Zhouyi Zhang

    Table Color Coding according to ABS Percent Variance From

    Milton Ayala

      Hi There,

       

      I am trying to create a dashboard with multiple worksheets to recreate report shown in the excel attached (Image follows). I am currently focused is the Fcst Vs month part (upper left part of the chart below) and am struggling to format correctly the color coding. Any suggestions would be highly appreciated.

       

      The idea is to color code according accuracy, this is the Absolute value of % difference Vs Prior forecast Version. Please note that the 1+11 means 1 month of actual + 11 months of forecast, therefore the January value will not change for any Forecast version after 1+11 .

       

      Using dummy values, thus excel example will not match with Tableau file