How To Average Across days

Fri, 21 Aug 2015 16:00:30 GMT

Hi,

I have following table that lists :

Key	Date	Duration	Total	Utlization
1	06/26/2013	0:26:00	0:50:00	52%
2	06/26/2013	0:26:00	0:50:00	52%
3	06/26/2013	0:26:00	0:50:00	52%
4	06/26/2013	0:25:00	0:50:00	50%
5	06/26/2013	0:36:00	0:50:00	72%
6	06/26/2013	0:26:00	0:50:00	52%
7	06/26/2013	0:26:00	0:50:00	52%
1	06/27/2013	2:56:00	10:47:00	27%
2	06/27/2013	2:55:00	10:47:00	27%
3	06/27/2013	1:40:00	10:47:00	15%
4	06/27/2013	1:40:00	10:47:00	15%
5	06/27/2013	2:05:00	10:47:00	19%
6	06/27/2013	1:40:00	10:47:00	15%
7	06/27/2013	2:55:00	10:47:00	27%

I created following bar chart:

The chart shows the Utilization across Two days for each Key.

Dimensions: Key and Date

Expression: Utilization

I want to show "one" bar that is the average Utilization across two or more days based on filter selection for each Key. How can I do that? Seems simple but the plot does not work?

Thanks

Re: How To Average Across days

Gysbert_Wassenaar — Fri, 21 Aug 2015 16:20:22 GMT

Remove Date as dimension and use avg(Utilization) as expression.

Re: How To Average Across days

Fri, 21 Aug 2015 17:16:16 GMT

It works. Thanks.

topic Re: How To Average Across days in QlikView

How To Average Across days

Re: How To Average Across days

Re: How To Average Across days