1 Reply Latest reply on Aug 8, 2013 11:54 AM by Joshua Milligan

    Conditional Coloring of Last Data Point

    Jessica Wood

      Hello Tableau Community!

       

      I have a series of raw data over time as well as the moving average of that data, which are both presented on the same graph. I would like to check if the LAST data point of the raw data is within some window, say 10%, of the moving average and if it is, color the point green, if not, color it red. I've been able to do this coloring for every point in my data series, but I cannot find a way for the coloration to only affect the last data point in the series. Also, simply putting a reference band in will not suffice either. Any ideas or thoughts / solutions would be greatly appreciated!!