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

Question

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?

Answer 1

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.