4 Replies Latest reply on Aug 14, 2012 1:29 PM by Jane Yang

    How can I do two-step coloring such that all rows with values greater than a dynamic average are highlighted?

    Jane Yang

      Hello,

       

      I have a bar graph that displays a per capita cost broken down by location on multiple levels (i.e. state, city). I've also put in a reference line that dynamically calculates the average per capita cost depending on how drilled down the location is. I'd like to color the marks (bars) in a bimodal fashion: if the per capita cost for that row is greater than the average, be dark; otherwise, be light. However, I only see how to give a hard-coded center value for the 2-step color. Is there a way to make a dynamic center value of AVG(PER CAPITA COST)?

       

      Thanks,

      Jane