Overview
Syntax | WINDOW_STDEV(Indicator,[Grouping field 1,Grouping field 2,...],[Sorting field 1,Sorting method,Sorting field 2,Sorting method,...],[Window upper limit,Window lower limit]) |
|
Parameter 1 | Indicator | The value cannot be empty. |
Parameter 2 | Grouping field | If the default value is used, data is not grouped by any field. |
Parameter 3 | Sorting field | If the default value is used, data is calculated in the default order. |
Parameter 4 | Sorting method | The value can be asc (ascending order) or desc (descending order). If one sorting method is defaulted, all sorting methods need to be defaulted. In this case, data is sorted by the sorting field in the ascending order. |
Parameter 5 | Window upper/lower limit | The value can be "first" (first row in the group) or "last" (last row in the group). Numeric constants are supported.
If the default value is used, data from the first row to the last row in the group is calculated (["first","last"]). |
Notes
For details, see WINDOW Function Overview - Notes.
Example
| Formula | Result | Note |
|---|---|---|
WINDOW_STDEV(SUM_AGG(Sales),[City],[SUM_AGG(Sales)],[-2,0]) | The sales standard deviations of three consecutive rows in the City group are calculated. |
