Chart: Sum of values of mulitiple entities then Avg / Max / Min over Time

[shane_spencer]

I collect Performance Metrics of a number of Servers at 5 minutes intervals then from this data I create a number of Charts.

Generally the Charts will show the Average, Maximum or Minimum 'Value' seen on the selected Server(s).

What I want to do is create a Chart where if multiple Servers are selected then the 'Value' at any 5 minute interval is the sum of all the Servers, but then when the Chart is viewed over the Day, or Month etc then only the Average / Max / Min of that sum of values is shown. (I don't want it to show the Sum for Hour, Day, Month etc)

i.e.

One of the Metrics I collect is Web Connections. In the example attached there are 2 Web Servers that make up part of this Service.

Currently the charts I've got shows the Average and Max connections across the selected Servers.

e.g.

Avg ({$<Main_metric={'Web Service(*)'},sub_Metric={'Current Connections'} >}value)

What I want to do is also see the Average and Max connections across the Service (the Sum of the Values on the 2 Servers).

Is that possible?

attached is the QlikView App with some sample data.

[Gysbert_Wassenaar]

If you're using QV11 you can use the conditional display expression for your Sum expression:

     =if(GetCurrentField([Date_drill])='Minute',0,1)

That means only show the expression if the current field of the Date_drill group is not Minute.

See attached qvw

[shane_spencer]

I'm using QV10.

That doesn't appear to be what I'm after though, as it simply gives the Sum connections over a given period. i.e. Total for the Hour, Day, Month.

What I'm after is the Concurrent Connections over the two (or more Servers) that make up a Service.

Then from that show the Average or Max or Min (depending on what I'm after) over the Hour, Day, Month number of connections on the Service (not individual Servers).

So whereas my chart in the attached example show the Avg and Max Connections on the Server(s) collected I want to do the same for the Connections to the Service.

[shane_spencer]

i.e.

Currently the Charts I've got will

a) Show the Average Value of all the Servers selected

- I want to show the Average of the Service (which is the Sum of the Values from each Server)

b) Show the Max Value seen on any one of the servers selected (i.e. 12 at 00:20 on GBW03345)

- I want to show the Max Concurrent Users on the Service (i.e at Hour 00 it's 15 at 00:45, at Hour 01 it's 16 at 01:10, on that day it would be 16 at Hour 01 etc)

GBW03344						GBW03345						SERVICE
MonthYear	Date	Hour	Minute	Value		MonthYear	Date	Hour	Minute	Value		TOTAL
Feb2013	06/02/2013	00	0	2		Feb2013	06/02/2013	00	0	10		12
Feb2013	06/02/2013	00	5	1		Feb2013	06/02/2013	00	5	10		11
Feb2013	06/02/2013	00	10	1		Feb2013	06/02/2013	00	10	10		11
Feb2013	06/02/2013	00	15	1		Feb2013	06/02/2013	00	15	10		11
Feb2013	06/02/2013	00	20	2		Feb2013	06/02/2013	00	20	12		14
Feb2013	06/02/2013	00	25	4		Feb2013	06/02/2013	00	25	8		12
Feb2013	06/02/2013	00	30	4		Feb2013	06/02/2013	00	30	8		12
Feb2013	06/02/2013	00	35	4		Feb2013	06/02/2013	00	35	9		13
Feb2013	06/02/2013	00	40	4		Feb2013	06/02/2013	00	40	10		14
Feb2013	06/02/2013	00	45	4		Feb2013	06/02/2013	00	45	11		15
Feb2013	06/02/2013	00	50	4		Feb2013	06/02/2013	00	50	5		9
Feb2013	06/02/2013	00	55	4		Feb2013	06/02/2013	00	55	6		10
Feb2013	06/02/2013	01	0	4		Feb2013	06/02/2013	01	0	6		10
Feb2013	06/02/2013	01	5	5		Feb2013	06/02/2013	01	5	7		12
Feb2013	06/02/2013	01	10	7		Feb2013	06/02/2013	01	10	9		16