5 Replies Latest reply on Aug 24, 2016 12:36 PM by nick.altmann

    Create a measure for secondary axis equivalent to per-cell reference line

    nick.altmann

      In the screenshot below of the attached workbook, I'm trying to plot a continuous ("continuous" in the "no-breaks" sense, not the Tableau time-series sense) blue line of the net value of the green "added" values and the red "removed" values.

       

      I've tried a few different approaches, but as close as I can some is by using per-cell reference lines.

       

      Part of the complexity comes from doing a count-distinct to get the values for "added" and "removed" since the id can be repeated, and I don't want to double-count them within a time period.

       

      added-removed-net.png