Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I am getting blank/null/whitespaces count as below .
But I have checked and my dimension does not have any of blank/null/whitepspaces.
I want to display this count (5000) in KPI separately.
Name | Count |
India | 1200 |
UK | 1500 |
Dubai | 3000 |
- | 5000 |
Regards,
Mahamed
Hello,
If my understanding is correct you have a field Name and this field is full with values of country names. To be more specific, you have confirmed that this field has all correct values and it doesn't contain any blank/null/whitespaces values. However,. when you create a table it shows "-" as country and count as "5000".
You can get similar behavior by limiting the records with If() statement in the dimension, when creating the table. For example:
1. I have the following dataset:
As you can see, all the values are present and none are missing or null
2. Now if you replace the dimension with expression: =If(Product = 'Prod1' OR Product = 'Prod2', Product) you will get the outcome:
As you can see, the last row appear as "-" (although we don't have any null values in Product field) and the count is "3". Based on what you have described, I assume that you have more or less a similar use case scenario on your side.
3. So if you would like to get the count of 3 in KPI, you just have to apply the logic of dimension limitation to the set analysis
4. This is the set analysis that I used in KPI: =Count({<Product={'Prod3'}>}Value) //Counting only the values where product = 3
5. The outcome is:
As you can see it has counted the values with "-".
I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, addressed your concerns or at least pointed you in the right direction, please mark it as Accepted Solution to give further visibility to other community members.
A potentially more simple explanation is that there's a missing key to another table, either because it's outright missing in the "fact" table or it's missing in the dimension table:
Sales, CountryCode
1200, IN
1500, UK
3000, AE
5000, DE
CountryCode, Country
IN, India
UK, UK
AE, Dubai
Hello,
If my understanding is correct you have a field Name and this field is full with values of country names. To be more specific, you have confirmed that this field has all correct values and it doesn't contain any blank/null/whitespaces values. However,. when you create a table it shows "-" as country and count as "5000".
You can get similar behavior by limiting the records with If() statement in the dimension, when creating the table. For example:
1. I have the following dataset:
As you can see, all the values are present and none are missing or null
2. Now if you replace the dimension with expression: =If(Product = 'Prod1' OR Product = 'Prod2', Product) you will get the outcome:
As you can see, the last row appear as "-" (although we don't have any null values in Product field) and the count is "3". Based on what you have described, I assume that you have more or less a similar use case scenario on your side.
3. So if you would like to get the count of 3 in KPI, you just have to apply the logic of dimension limitation to the set analysis
4. This is the set analysis that I used in KPI: =Count({<Product={'Prod3'}>}Value) //Counting only the values where product = 3
5. The outcome is:
As you can see it has counted the values with "-".
I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, addressed your concerns or at least pointed you in the right direction, please mark it as Accepted Solution to give further visibility to other community members.
A potentially more simple explanation is that there's a missing key to another table, either because it's outright missing in the "fact" table or it's missing in the dimension table:
Sales, CountryCode
1200, IN
1500, UK
3000, AE
5000, DE
CountryCode, Country
IN, India
UK, UK
AE, Dubai