Skip to content
Infoveave Help

FIRSTNONBLANKX

The FIRSTNONBLANKX function in Infoveave identifies the first 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 meeting the specified condition.

Remark

FIRSTNONBLANKX extracts the initial non-empty data point while considering a condition, useful for responsive monitoring and alerting. It provides selective and context-aware results.

Syntax

FIRSTNONBLANKX(<expression>,<condition>)

FIRSTNONBLANKX in Board Expression

Parameters

ParameterDescription
ExpressionA placeholder replaced with the actual widget and measure names.
ConditionA placeholder replaced with the condition filter.
Widget NameThe specific name 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 ValueSpecific dimension items within the dimension column used for widget visualization.

Steps to use FIRSTNONBLANKX in Board Expression

  1. Write the FIRSTNONBLANKX function. For example FIRSTNONBLANKX(<expression>,<condition>)
  2. Where expression equals 'Widget Name'[Measure] and condition equals [Dimension Name]="Dimension Value".Replace Widget Name, Measure, Dimension Name, and Dimension Value with your actual values.
  3. To learn how to configure an Expression in Infoveave, visit Configure Expression.

FIRSTNONBLANKX in Calculated Columns

ParameterDescription
ExpressionA placeholder replaced with the column names.
ConditionA placeholder replaced with the condition filter.
Column NameThe name of the column containing the values you want to analyze.
Filter ConditionA filter condition (string or numeric) that returns data points meeting the defined condition.

Steps to use FIRSTNONBLANKX in Calculated Columns

  1. Write the FIRSTNONBLANKX function. For example FIRSTNONBLANKX(<expression>,<condition>)
  2. Replace <expression> with the required [Column Name] and <condition> with [Column Name]="Filter Condition".
  3. Replace Column Name and Filter Condition with your actual values.
  4. To learn how to add calculated columns in Infoveave, visit Calculated Columns.