Definition:
- The DISTINCTCOUNT function in Infoveave calculates the number of unique, distinct values in a column or dataset. It counts how many different items are present without considering duplicates.
Applicable to:
Calculated Columns ExpressionsReturn Value:
- The return value of the DISTINCTCOUNT function is an integer representing the count of unique, non-duplicate values in the specified column.
Remark:
- DISTINCTCOUNT is useful when you want to know how many distinct items are in a particular column, such as counting the number of unique customers, products, or categories.
- DISTINCTCOUNT function can be used across Date, Strings and Numbers.
- DICTINCTCOUNT function takes all values into account.
Syntax:
DISTINCTCOUNT(<expression>)
DISTINCTCOUNT 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 DISTINCTCOUNT function. For instance:
DISTINCTCOUNT(<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 DISTINCTCOUNT 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:
- You're overseeing a dataset and an Infoboard titled 'Green Solar' within your Energy Consumption Analysis System. Your goal is to count the number of unique solar customers without counting any customer twice. This is vital for assessing customer engagement and ensuring data accuracy.
- Dashboard Name: Consumption Analysis
- Widget Name: Green
- Measure Name: Customers (representing the number of customers)
- You can use the DISTINCTCOUNT function like this:
DISTINCTCOUNT('Green'[Customers])=100
DISTINCTCOUNT 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 DISTINCTCOUNT function. For instance:
DISTINCTCOUNT(<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 distinct values in the column COUNTRY.
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 DISTINCTCOUNT function like:
DISTINCTCOUNT([COUNTRY])
ORDER DATE | COUNTRY | CATEGORY | UNIT PRICE | MARKET PRICE | QUANTITY | TOTAL ENTRIES |
03-01-2024 | Brazil | Baby Food | 38.41 | 43.7874 | 2 | 4 |
07-01-2024 | Japan | Spices | 45.56 | 50.8155 | 20 | 4 |
Japan | 43.7874 | 10 | 4 | |||
18-01-2024 | 32.3019 | 4 | 4 | |||
22-01-2024 | Brazil | Cosmetics | 28.335 | 23.0109 | 7 | 4 |
26-01-2024 | Canada | 20.185 | 23.0109 | 9 | 4 | |
04-01-2024 | France | Cereal | 25.26 | 28.7964 | 9 | 4 |
09-01-2024 | Brazil | Cereal | 44.575 | 50.8155 | 8 | 4 |
14-01-2024 | Brazil | Snacks | 20.185 | 4 | 4 | |
Brazil | Cosmetics | 40.485 | 46.1529 | 2 | 4 |