COUNTNOBLANKX

Definition:
  • The COUNTNOBLANKX function is used to count the number of rows within a specified table or dataset that meet a specific condition. It evaluates each row against the given condition and increments the count when the condition is true. This function is particularly useful for filtering and counting data based on specified criteria.
Return Value:
  • The return value of the COUNTNOBLANKX function is an integer representing the count of rows that satisfy the condition within the specified table or dataset.
Remark:
  • COUNTNOBLANKX is a useful function when you want to count rows based on specific criteria, such as filtering rows in a dataset that meet certain conditions or constraints.
Syntax:

COUNTNOBLANKX(<expression>,<condition>)

COUNTNOBLANKX in Board Expression

Parameters
Expression A placeholder in a function that is replaced with the actual widget and measure names.
Condition A placeholder in a function that is replaced with the condition filter.
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.
Dimension Represents the dimension column that is being displayed or analyzed using the widget.
Dimension Value Represents the specific dimension items within the dimension column used for the visualization in the widget.
  • Write the COUNTNOBLANKX function. For instance:

COUNTNOBLANKX(<expression>,<condition>)

  • Where expression equals 'Widget Name'[Measure] and condition equals [Dimension Name]="Dimension Value"
    • Replace Widget Name with the actual name of your widget ,Measure with the required measure name, Dimension with the required dimension name and Dimension Value with the dimension value of the selected dimension name.
  • Set the COUNTNOBLANKX function based on the scenario.
  • To learn how to configure an Expression in Infoveave, visit the section Configure Expression.

COUNTNOBLANKX in Calculated Columns

Parameters
Expression A placeholder in a function that is replaced with the actual widget and measure names.
Condition A placeholder in a function that is replaced with the condition filter.
Column Name The name of the column in the dataset or Datasource that contains the values you want to analyze.
Filter Condition A filter condition returns the data points that meet the defined condition that you want to analyze. The filter condition can be either a string or a numeric.
  • Write the COUNTNOBLANKX function. For instance:

COUNT(<expression>,<condition>)

  • Replace <expression> with required [Column Name] and <condition> equals [Column Name]="Filter Condition"
  • Replace Column Name with the actual name of your column and Filter Condition with the required condition to be applied on the columns.
  • To learn how to add calculated columns in Infoveave, visit the section Calculated Columns.
Was this article helpful to you? Yes No

How can we help?

Copyright © 2024 Noesys Software Pvt. Ltd.

Infoveave is a proprietary product of Noesys.  All Rights Reserved.