The CUMMULATIVE function in Infoveave is used to calculate the cumulative total of a numerical column in a dataset. It computes the running total of the values in the column, where each row’s total includes the current row’s value plus the total from all previous rows.
Applicable to
Calculated Columns
Expressions
Return Value
The return value of the CUMMULATIVE function is a numerical column containing the cumulative totals for each row in the dataset.
Remark
The CUMMULATIVE function is useful for analyzing trends and patterns in data over time.
It allows you to see how a particular value accumulates or grows over a series of observation.
CUMMULATIVE function is applicable only for numeric values.
It does not take nulls and blanks into account.
Syntax
CUMMULATIVE(<expression>)
CUMMULATIVE in Board Expression
Expression
A placeholder in a function that is replaced with the actual widget and measure names.
Widget Name
The specific name or identifier of the widget being used for data visualization in the specific Infoboard.
Measure
Represents the name of the measure that is being displayed or analyzed using the widget.
Steps to Use CUMMULATIVE
Write the CUMMULATIVE function. For instance CUMMULATIVE(<expression>)
Replace <expression> with 'Widget Name'[Measure].Replace Widget Name with the actual name of your widget and Measure with the corresponding measure name.
To learn how to configure an Expression in Infoveave, visit the section Configure Expression.
Example
Scenario
Imagine you are managing an Energy Dashboard, and you want to define a specific action based on a condition using Expressions. Let the condition to meet in this example be that you’re calculating the cumulative sum of customers and you want to trigger a specific action if this is greater than 7000000.
Scenario Details
Dashboard Name Energy Dashboard
Widget Name Total Customer
Measure Name Customers (representing the number of customers)
