Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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)
Hi!
Here is a simple example. Hope that helps.
Rebeca
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)