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

    Split dual axes when averaging

    Elizabeth Chan



      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?