9 Replies Latest reply on Oct 28, 2013 8:13 AM by Jonathan Drummey

    How to plot the median of a measure, by different dimension values

    logicblox.huang

      I have a bar chart like the following one.  The vertical axis is a measure: duration, where the color detail indicates 3 different systems.  The horizontal axis are the different jobs being run by the systems.

       

      I would like to plot the median duration for each system, as 3 horizontal lines. I can't figure out for the life of me how to do it.  Things I've tried:

      • I can add one reference median line for the chart, but it doesn't let me separate that out by detail
      • I tried to create 3 different calculated fields, one for the duration of each system.  I can create a combined chart of 2 of them, using dual axis. Then I can add reference median line for each one. But that doesn't let me plot the 3rd system.
      • I tried to create a calculated field that just maps a system to its median. But I can't seem to be able to because it involved a formula that adds a condition on top of an aggregation (median).

       

      Any help would be much appreciated!

       

      Screen Shot 2013-10-26 at 7.13.40 PM.png

       

      I'm trying to plot the median of three different levels in a dimension