3 Replies Latest reply: Sep 6, 2011 5:38 AM by Stefan Wühl RSS

    Min, Median, Max agregated/sum by entity

      Hi,

       

      I have a table like the one below.

       

           ENTITY,   YEAR,   MONTH,   VALUE

           ABC,   2011,   1,   11
           ABC,   2011,   2,   10
           ABC,   2011,   3,   9

           QWE,   2011,   1,   19
           QWE,   2011,   2,   20
           QWE,   2011,   3,   21

           XYZ,   2011,   1,   14
           XYZ,   2011,   2,   15
           XYZ,   2011,   3,   16

       

      I want do creat a gauge chart, where appears the Min, Median and Max of the "Value" field, agregated/sum by "Entity".

       

       

      Min          Median          Max

      ABC          XYZ             QWE

      30               45               60

      |                  |                  |

      #######################

       

       

      Is this possible?

       

       

       

      Many thanks,

       

      Pedro.