*** 38,44 **** data, on which the analytic function will operate, within a group. This clause can be used to have the analytic function compute its value based on any arbitrary sliding or anchored window within a group. ! _:Exemple: _:This example shows how to use the analytical function *SUM* to perform a cumulative sum. First, we fill some values in a table. The table is very simple and consists of the field _dt_ and _xy_ only. Note, that for a given date it is possible to insert multiple rows which is exactly what I do here. What I am interested is to extract the cumulative sum for each day in the table. That is, if I have three entries for the same date, for example 3, 4 and 5, I don't want the sum to only be 3+4+5 for each row, but 3 for the first row, 3+4 for the second row and 3+4+5 for the third row. --- 38,44 ---- data, on which the analytic function will operate, within a group. This clause can be used to have the analytic function compute its value based on any arbitrary sliding or anchored window within a group. ! _:Example: _:This example shows how to use the analytical function *SUM* to perform a cumulative sum. First, we fill some values in a table. The table is very simple and consists of the field _dt_ and _xy_ only. Note, that for a given date it is possible to insert multiple rows which is exactly what I do here. What I am interested is to extract the cumulative sum for each day in the table. That is, if I have three entries for the same date, for example 3, 4 and 5, I don't want the sum to only be 3+4+5 for each row, but 3 for the first row, 3+4 for the second row and 3+4+5 for the third row.
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|