3 Replies Latest reply on Aug 14, 2018 12:12 PM by Jim Dehner

    Customize Median Caculation from the Analytics Pane

    ahmed.arafat

      Hello all,

       

      I have been trying to customize the Median Calculation from the Analytics pane to calculate it only with specific measures and not all measures on the graph.

       

      Here is what I am trying to do. The median with 95% CI is plotted once for all measures. I would like to calculate it using the (orange color group) measures only, please note there is one measure in white color on the graph which I need to exclude from the median calculation and compare where it is positioned comparing to the median of the other orange measures. Any suggestion would be appreciated!

       

      Attached is the workbook.

       

       

       

      Thank you,

      Ahmed