2 Replies Latest reply on Jul 6, 2018 8:36 AM by Elizabeth Chan

    Split dual axes when averaging

    Elizabeth Chan

      Hello,

       

      I am having an issue with dual axes and averages. One axis, EE, is comprised of single points, where the other axis, CI, is a line between two points.

       

      Everything looks fine when I use other calculations, such as the median (attachment 1), but splits so that CI and EE are each on separate rows when I change the calculation to average (attachment 2).

       

      There are some complicated join and unions going on, but all of those things remain unchanged between the two screenshots. Any ideas?

       

      Thanks,

      Elizabeth