1 Reply Latest reply: Feb 24, 2015 12:18 PM by Onno van Knotsenburg RSS

    Total the values on bar graph with two dimensions.

      Hi,

       

      I have created a bar graph with one dimension (Platform), and wrote a expression to count the number of  distinct servers.

      [COUNT(DISTINCT IP_ADDRESS)

      In my bar graph under 'Dimension Limit' I have selected 'show Total ' and it works fine with single dimension.

       

      Here are the results

       

      Platform                               count

      Windows 2003                        50
      Windows 2008                        100

      AIX                                         50

      Total                                       200

       

      Now I'm trying to do some thing similar but with two dimensions (Platform , Function)

      This should be the final result.

       

      Platform                               Function           Count

      Windows 2003                        Hardening             30

      Windows 2003                        Patching               20

      Windows 2008                        Hardening             70

      Windows 2008                        Patching               30

      AIX                                        Hardening             30

      AIX                                        Patching               20

       

      TOTAL Hardening                                               130 

      TOTAl Patching                                                  70

       

      So basically I want to create two TOTAL bars for the dimension function.

      When I select the 'show total' option under dimension limit for each dimension

      I dont get the desired results.

       

      has anyone of you came across a similar scenario, If yes how did you solved it.

       

      Thanks,

       

      Aniket