Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have a table with timestamps and value. for example
stamp | Value |
6:05:00 | 39,41 |
6:12:35 | 27,93 |
6:20:10 | 25,13 |
6:27:45 | 21,2 |
6:35:21 | 19,94 |
6:39:43 | 29,54 |
6:44:06 | 107,85 |
6:48:28 | 24,37 |
6:52:51 | 40,8 |
6:57:14 | 100,55 |
7:01:36 | 58,09 |
7:05:03 | 89,2 |
7:08:30 | 51,45 |
7:11:57 | 81,24 |
7:15:24 | 58,11 |
7:18:51 | 66,5 |
7:22:18 | 76,02 |
7:25:44 | 97,27 |
7:29:11 | 125,55 |
7:32:38 | 50,12 |
7:35:48 | 70,81 |
7:38:58 | 99,11 |
i need to create a new column, each value in the new colum must be the sum of the above values of the field Value but only of the revords where the stamp time is lower than 60 minutes of the first record.
For excample in the above table, the new value of the record 1 will be the sum of the above records records where the stamp is lower than 6:05:00 + 60 minutes --> 7:05:00, and so it must sum the values from 39,41 (stamp = 39,41) to 58,09 (stamp 7:01:36).
In the secord rows the same, the new value field must sum the values from 27,93 (stamp 6:12:35) to the value 81,24(stamp 7:11:57)
and so on....
stamp | Value | NewSum Value |
6:05:00 | 39,41 | 494,81 |
6:12:35 | 27,93 | 677,29 |
6:20:10 | 25,13 | 773,97 |
6:27:45 | 21,2 | …. |
6:35:21 | 19,94 | |
6:39:43 | 29,54 | |
6:44:06 | 107,85 | |
6:48:28 | 24,37 | |
6:52:51 | 40,8 | |
6:57:14 | 100,55 | |
7:01:36 | 58,09 | |
7:05:03 | 89,2 | |
7:08:30 | 51,45 | |
7:11:57 | 81,24 | |
7:15:24 | 58,11 | |
7:18:51 | 66,5 | |
7:22:18 | 76,02 | |
7:25:44 | 97,27 | |
7:29:11 | 125,55 | |
7:32:38 | 50,12 | |
7:35:48 | 70,81 | |
7:38:58 | 99,11 | |
7:42:08 | 140,6 | |
7:45:17 | 164,24 | |
7:48:27 | 59,69 | |
7:51:37 | 80,4 |
is there a way to do this in the scrip or in a graph expresion using rangesum or other function
thanks in advance for your help
regards
Anyone know if there is a way to use rangesum with above function but filtering the records that above function must take, for example filtering by the value of other field.
Thanks in advance
regards
Dimension : stamp
Expression:
1) Sum(Value)
2) If(stamp < '7:05:00', Rangesum(Above(Sum(Value),0,RowNo(TOTAL))))