Insights
Guide to Infoboard Designer
Create Infoboard
Infoveave Board Expressions
Sub Views
Infoveave FunctionsDefinition:
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.
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.
Syntax:
CUMMULATIVE(<Reference>)
Note
CUMMULATIVE function in Board Expression:
- Write the CUMMULATIVE function. For instance:
CUMULATIVE(<Reference>)
- Replace
<Reference>with'Widget Name'[Measure] - Replace Widget Name with the actual name of your widget and Measure with the corresponding measure name.
- Set the condition with the CUMMULATIVE function based on the scenario. For instance, you can set the count entries that meet a certain criteria, as the condition.
- Expressions help you add visual effects to your dashboard through widget-specific conditions. It is important to note that the Expressions are not meant to manage or modify data.
- To learn how to configure an Expression in Infoveave, visit the section Configure Expression.
Note
CUMMULATIVE function in calculated column:
To learn how to use Infoveave functions in calculated columns, visit Add Calculated Column under Sources.
- Write the CUMMULATIVE function. For instance:
CUMMULATIVE(<Reference>)
- Replace
<Reference>with the[Column Name]with the required column name in the dataset..
