--- title: COUNTNOBLANK description: COUNTNOBLANK --- import { Aside, Steps } from '@astrojs/starlight/components'; # COUNTNOBLANK The COUNTNOBLANK function calculates the number of non-blank or non-null cells or entries in a column. It counts the cells or entries that contain data. ## Applicable to * Calculated Columns * Expressions ## Return Value The return value of the COUNTNOBLANK function is an integer representing the count of non-blank or non-null cells or entries in the specified column. ## Remark * COUNTNOBLANK is a valuable function for assessing data completeness and identifying the presence of data within a specific column. * COUNTNOBLANK function returns the total count excluding nulls and blanks. * COUNTNOBLANK function can be used across Dates, Strings, and Numbers. ## Syntax ``` COUNTNOBLANK() ``` ## COUNTNOBLANK in Board Expression ## Parameters | 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 COUNTNOBLANK 1. Write the COUNTNOBLANK function. For instance `COUNTNOBLANK` 2. Replace `` with `'Widget Name'[Measure]`.Replace **Widget Name** with the actual name of your widget and **Measure** with the corresponding measure name. 3. Set the condition with the `COUNTNOBLANK` function based on the scenario. For instance, you can set the count of non-blank or not-null entries that meet a certain criterion, as the condition. 4. To learn how to configure an Expression in Infoveave, visit the section [Configure Expression]()./insights-v8/advanced-configuration/#configuring-expressions **Scenario** * Imagine you are managing a Consumption Dashboard, and one of your key objectives is to ensure the data within it is complete and accurate. Specifically, you want to count the number of non-blank entries in the 'Customers' column of your dataset continuously. If this count ever reaches 20, you want to trigger a specific action on your dashboard to monitor and manage data completeness effectively. **Scenario Details** * **Dashboard Name** Offer Switch Dashboard * **Widget Name** New Offer Switches * **Measure Name** Customers (quantifying the number of customers) * **Dimension Name** Discount Types (categorizing customers based on their payment behavior) * **Dimension Value** "Big Sales" (representing customers who switched ) **Objective** Your objective is to count the number of non-blank entries in the 'Customers' column and determine if this count is equal to 20. If this condition is met, you want to trigger a particular action on your dashboard. You can use the COUNTNOBLANK function as ``` COUNTNOBLANK('New Offer Switches'[Customers])=20 ``` ## COUNTNOBLANK in Calculated Columns ## Parameters | Expression | A placeholder in a function that is replaced with the column names. | |---|---| | Column Name | The name of the column in the dataset or Datasource that contains the values you want to analyze. | ## Steps to use COUNTNOBLANK in Calculated Columns 1. Write the `COUNTNOBLANK` function. For instance `COUNTNOBLANK()` 2. Replace `` with `[Column Name]` Replace **Column Name** with the actual name of your column required. 3. To learn how to add calculated columns in Infoveave, visit the section [Calculated Columns](/studio-v8/datasources/calculated-columns-datasource/).