14 Replies Latest reply on Apr 28, 2018 10:10 PM by Shinichiro Murakami

    Color Filled Line Chart based on single month data?

    mike.shapiro.0

      I'm trying to color code an area line chart based on the last months performance YoY.  For that, I've already created the formula in Alteryx that develops a string text indicator for me at a monthly level.  It simply returns a string of 'Green' 'Red' 'Gray', in a column etc per row and each row contains the date.

       

      My question is how I can color an entire line chart based on latest months single string value?  In the attached example, I want to use  [color - Supply YoY] to color.

       

      It should see the latest months value for the dimension only to color the whole line and fill with a single color

      KPI tile.png

       

       

      Right now, it grabs each row / month and looks like this:

      ugly.png