fromCalculations | Document A document (IData object) containing the values to combine with toCalculations. | ||
Key | Description | ||
count | String Optional. Number of entries in the result set for the window. The supplied value must be a number that is represented as a String. | ||
max | String Optional. Maximum value for the parameter in the window to which the CALCULATE step was applied. The supplied value must be a number that is represented as a String. | ||
min | String Optional. Minimum value for the parameter in the window to which the CALCULATE step was applied. The supplied value must be a number that is represented as a String. | ||
sum | String Optional. Sum of the values for the parameter in the window to which the CALCULATE step was applied. The supplied value must be a number that is represented as a String. | ||
first | Object Optional. The first value for the parameter in the window to which the CALCULATE step was applied. | ||
last | Object Optional. The last value for the parameter in the window to which the CALCULATE step was applied. | ||
toCalculations | Document. A document (IData object) containing the calculations to combine with fromCalculations. | ||
Key | Description | ||
count | String Optional. Number of entries in the result set for the window. The supplied value must be a number that is represented as a String. | ||
max | String Optional. Maximum value for the parameter in the window to which the CALCULATE step was applied. The supplied value must be a number that is represented as a String. | ||
min | String Optional. Minimum value for the parameter in the window to which the CALCULATE step was applied. The supplied value must be a number that is represented as a String. | ||
sum | String Optional. Sum of the values for the parameter in the window to which the CALCULATE step was applied. The supplied value must be a number that is represented as a String. | ||
first | Object Optional. The first value for the parameter in the window to which the CALCULATE step was applied. | ||
last | Object Optional. The last value for the parameter in the window to which the CALCULATE step was applied. |
toCalculations | Document. The toCalculations document (IData object) combined with the values in fromCalculations. | ||
Key | Description | ||
count | String Conditional. Combined count from the calculations. Sum of the input toCalculations/count and the input fromCalculations/count. This value is returned only if count was included in fromCalculations and/or toCalculations. | ||
max | String Conditional. Maximum value in the combined result calculations for the parameter to which the CALCULATE step was applied. This value is returned only if max was included in fromCalculations and/or toCalculations. | ||
min | String Conditional. Minimum value in the combined result calculations for the parameter to which the CALCULATE step was applied. This value is returned only if min was included in fromCalculations and/or toCalculations. | ||
sum | String Conditional. Sum of the sum values in the combined results sets for the parameter to which the CALCULATE step was applied. This value is returned only if count was include in fromCalculations and/or toCalculations. | ||
first | Object Conditional. The first value in the combined results for the parameter to which the CALCULATE step was applied. This value is returned only if first was included in fromCalculations and/or toCalculations. | ||
last | Object Conditional. The last value in the combined results for the parameter to which the CALCULATE step was applied. This value is returned only if last was included in fromCalculations and/or toCalculations. |
count=10 | max=5 | sum=30 |
count=10 | max=3 | sum=20 |
count=20 | max=5 | sum=50 |
count=5 | max=6 | sum=10 |
count=25 | max=6 | sum=60 |