Running average above 10 minutes

[qlikconsultant]

Hi,

I have a table with date, time and count and I need a running average of the last 10 minutes. I found the following post (http://community.qlik.com/message/95999#95999). But im not get this solution working for my problem. Thanks for any help or or ideas.

date	time	count
01.05.2012	00:00	2
01.05.2012	00:01	5
01.05.2012	00:02	3
01.05.2012	00:03	4
01.05.2012	00:04	2
01.05.2012	00:05	1
01.05.2012	00:06	3
01.05.2012	00:07	1
01.05.2012	00:08	3
01.05.2012	00:09	4
01.05.2012	00:10	12
01.05.2012	00:11	5
...	...	...
01.06.2012	23:59	4

[#2]

Hi!

Here is a simple example. Hope that helps.

Rebeca

[qlikconsultant · Accepted solution]

I found a different solution:

round((above(sum(count),10)

+above(sum(count),9)

+above(sum(count),8)

+above(sum(count),7)

+above(sum(count),6)

+above(sum(count),5)

+above(sum(count),4)

+above(sum(count),3)

+above(sum(count),2)

+above(sum(count),1))/10)