Definition:
- COUNT is a function that calculates the number of all entries within a specified column. It helps quantify the occurrence of data points in a dataset.
Applicable to:
Calculated Columns Expressions
Return Value:
- The return value of the COUNT function is an integer representing the count of all entries.
Remark:
- COUNT is a versatile function can be used for assessing the size of a dataset.
- COUNT function returns the total count including nulls and blanks.
- COUNT function can be used across Dates, Strings, and Numbers.
Syntax:
COUNT(<expression>)
COUNT in Board Expression
Note
Expressions help you add visual effects to your dashboard through widget-specific conditions. It is important to note that the Expressions are not meant to manage or modify data.
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. |
- Write the COUNT function. For instance:
COUNT(<expression>)
- Replace
<expression>
with'Widget Name'[Measure]
- Replace Widget Name with the actual name of your widget and Measure with the corresponding measure name.
- Set the condition with the COUNT function based on the scenario. For instance, you can set the count entries that meet a certain criterion, as the condition.
- To learn how to configure an Expression in Infoveave, visit the section Configure Expression.
Example
Scenario:
- Imagine you are responsible for overseeing a Solar Grid Management System, and your primary objective is to ensure that the grid operates efficiently and safely. One critical aspect is monitoring the number of solar customers connected to the grid in real-time.
- Dashboard Name: Solar Energy Dashboard
- Widget Name: Solar In
- Measure: Solar Customers (quantifying the number of solar customers)
- Dimension: Discount Types (categorizing customers based on their payment behavior)
- Dimension Value: "Always" (representing customers who pay their bills on time)
- You can use the COUNT function like this:
COUNT('Solar In'[Solar Customers])=100
COUNT in Calculated Columns
Parameters
Expression | A placeholder in a function that is replaced with the actual widget and measure names. |
Column Name | The name of the column in the dataset or Datasource that contains the values you want to analyze. |
- Write the COUNT function. For instance:
COUNT(<expression>)
- Replace
<expression>
with[Column Name]
- Replace Column Name with the actual name of your column required.
- To learn how to add calculated columns in Infoveave, visit the section Calculated Columns.
Example
Objective: Consider that you have the below sales dataset, your goal is to count the number of rows in the dataset.
ORDER DATE | COUNTRY | CATEGORY | UNIT PRICE | MARKET PRICE | QUANTITY |
2024-01-03 | Brazil | Baby Food | 38.41 | 43.7874 | 2 |
2024-01-07 | Japan | Spices | 45.56 | 50.8155 | 20 |
Japan | 43.7874 | 10 | |||
2024-01-18 | 32.3019 | 4 | |||
2024-01-22 | Brazil | Cosmetics | 28.335 | 23.0109 | 7 |
2024-01-26 | Canada | 20.185 | 23.0109 | 9 | |
2024-01-04 | France | Cereal | 25.26 | 28.7964 | 9 |
2024-01-09 | Brazil | Cereal | 44.575 | 50.8155 | 8 |
2024-01-14 | Brazil | Snacks | 20.185 | 4 | |
Brazil | Cosmetics | 40.485 | 46.1529 | 2 |
- You can use the COUNT function like:
COUNT([COUNTRY])
ORDER DATE | COUNTRY | CATEGORY | UNIT PRICE | MARKET PRICE | QUANTITY | TOTAL ENTRIES |
03-01-2024 | Brazil | Baby Food | 38.41 | 43.7874 | 2 | 10 |
07-01-2024 | Japan | Spices | 45.56 | 50.8155 | 20 | 10 |
Japan | 43.7874 | 10 | 10 | |||
18-01-2024 | 32.3019 | 4 | 10 | |||
22-01-2024 | Brazil | Cosmetics | 28.335 | 23.0109 | 7 | 10 |
26-01-2024 | Canada | 20.185 | 23.0109 | 9 | 10 | |
04-01-2024 | France | Cereal | 25.26 | 28.7964 | 9 | 10 |
09-01-2024 | Brazil | Cereal | 44.575 | 50.8155 | 8 | 10 |
14-01-2024 | Brazil | Snacks | 20.185 | 4 | 10 | |
Brazil | Cosmetics | 40.485 | 46.1529 | 2 | 10 |