Skip to content
Infoveave Help

LASTNONBLANKX

The LASTNONBLANKX function in Infoveave identifies the last non-blank (non-empty) value in a dataset or column that meets a specific condition, filtered by the current context.

Applicable to

  • Calculated Columns
  • Expressions

Return Value

The first non-blank value in the dataset or column that meets the specified condition.

Remark

LASTNONBLANKX extracts the initial non-empty data point within datasets, considering a condition. It’s valuable for responsive monitoring and alerting applications, providing selective and context-aware results.

Syntax

LASTNONBLANKX(<expression>,<condition>)

LASTNONBLANKX in Board Expression

ParameterDescription
ExpressionA placeholder replaced with actual widget and measure names.
ConditionA placeholder replaced with the condition filter.
Widget NameThe specific name or identifier of the widget used for data visualization in the Infoboard.
MeasureThe name of the measure displayed or analyzed using the widget.
DimensionThe dimension column displayed or analyzed using the widget.
Dimension ValueThe specific dimension items within the dimension column used for visualization in the widget.

Steps to Use LASTNONBLANKX

  1. Write the LASTNONBLANKX function. For instance LASTNONBLANKX(<expression>,<condition>)
  2. Where expression equals 'Widget Name'[Measure] and condition equals [Dimension Name]="Dimension Value".Replace Widget Name with your widget’s name, Measure with the required measure name, Dimension with the required dimension name, and Dimension Value with the dimension value of the selected dimension name.
  3. To learn how to configure an Expression in Infoveave, visit the Configure Expression section.

LASTNONBLANKX in Calculated Columns

ParameterDescription
ExpressionA placeholder replaced with column names.
ConditionA placeholder replaced with the condition filter.
Column NameThe name of the column in the dataset or Datasource containing the values you want to analyze.
Filter ConditionA filter condition returning data points meeting the defined condition you want to analyze. Can be string or numeric.

Steps to Use LASTNONBLANKX in Calculated Columns

  1. Write the LASTNONBLANKX function. For instance LASTNONBLANKX(<expression>,<condition>)
  2. Replace <expression> with the required [Column Name] and <condition> equals [Column Name]="Filter Condition"
  3. Replace Column Name with your column’s name and Filter Condition with the required condition.
  4. To learn how to add calculated columns in Infoveave, visit the Calculated Columns section.