Total the values on bar graph with two dimensions.

Mon, 23 Feb 2015 23:56:45 GMT

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

Re: Total the values on bar graph with two dimensions.

oknotsen — Tue, 24 Feb 2015 17:18:32 GMT

Maybe not really what you are looking for, but you could consider making a pivot table instead.

Platform on the left, Function on the top, turn on "partial sum" on platform.

Would that help?