7 Replies Latest reply on Aug 22, 2017 8:09 AM by Brad Sheridan

    Custom trend line calculation used for color?

    Brad Sheridan

      Hey there Community!  I've got a question that has stumped me for the past day (it's possible that this can't even be accomplished)

       

      I've got the dashboard tab shown below.  Obviously when a bar is selected at the top, the bottom line chart renders for the 'company' only.  As you can see, I added a trend line to the bottom chart.

       

      What I'd now like to do is:

      1) somehow capture the trend line formula in a calculated field

      2) use that calculation to color the bars on top.

       

      Basically I want the bars colored to indicate where the slope is declining/negative vs. increasing/positive

       

      thoughts?