How to replace the count(field) which is missing in data with zero in tableau?

0 votes
I have a KPI which gives me the count of "High Risk" orders. But for any particular Customer I do not have the "High Risk" order then the count on KPI should give me 0 value. Now, since I don't have the High Risk value associated for that Customer in my data set, it is returning blank.How do I show 0 value in the KPI?
Dec 4, 2019 in Tableau by anonymous
• 120 points
98 views

1 answer to this question.

+1 vote

Use calculated field to create a dummy column and assign value to 0 for those customers that dont have High Risk value.

If order is a column in your dataset, try creating a calculated field like below.

if [Order] ! = "High Risk" then 0 else [Value]

When you group this calculated column acording to values. you can find customers that have no high risk as 0 value. Then use KPI. 

answered Dec 21, 2019 by sindhu

Related Questions In Tableau

0 votes
0 answers

How to export the IdP (Identity provider) XML Metadata from Keycloak which is imported to Tableau?

Keycloak version 1.6.1, Goal: Keycloak should act ...READ MORE

Mar 28, 2018 in Tableau by Atul
• 5,530 points
591 views
0 votes
1 answer

how to get the count of non zero values in a row

In first part you should solve the ...READ MORE

answered Apr 4, 2018 in Tableau by Atul
• 10,250 points
261 views
0 votes
1 answer

Is it possible to join tables on the basis of some calculated field in Tableau?

@Ammy999, You can not perform join in ...READ MORE

answered May 16, 2018 in Tableau by Mathew1810
149 views
0 votes
1 answer

How to refresh the extracted data source automatically in Tableau Desktop?

Hi AwesomeSauce, This comes up every so often!  Tableau ...READ MORE

answered Aug 13, 2018 in Tableau by Naruto
• 710 points
1,695 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,250 points
2,712 views
+1 vote
1 answer
+1 vote
1 answer

Is it possible to access or install tableau desktop insde tableau server?

Try to understand this, Tableau Server and ...READ MORE

answered Mar 29, 2018 in Tableau by xyz
• 1,550 points

edited Mar 29, 2018 by xyz 78 views
0 votes
1 answer

Hover text shows numbers in decimal points

Do this: 1. Right click on the calculated ...READ MORE

answered Apr 2, 2018 in Tableau by QueenBee
• 1,820 points
49 views
0 votes
1 answer

Dropdown to change x-axis in Tableau

You need to create a  str datatype parameter ...READ MORE

answered Apr 3, 2018 in Tableau by QueenBee
• 1,820 points
72 views
0 votes
1 answer

Tableau Desktop- Tableau Server

No, you don't necessarily need to purchase ...READ MORE

answered Apr 3, 2018 in Tableau by QueenBee
• 1,820 points
77 views