Category / Section
How to count multiple columns without null values
Published:
When working with data in BoldBI widgets, you may encounter situations where you want to display only the rows with non-null values. This article will guide you through the process of filtering out null values and displaying the correct count of rows in your widget.
Steps to Count Multiple Columns without Null values
- Check the if the column null values and return 1 if not null and sum it.
Create the above expressions for the required columns.
Drag and drop the expression columns while assigning the data to the widget.
Now you can see the count of columns without null values in the table.
Related Links
SG
