I connect my tableaue to a data warehouse and it returns only 75% of numbers ,the rest 25% is a constant value 2 ,how can I input this .
Now this is how the table is going to be , I need to fill in value for missing rows, There is an unique identifier for these null field and it is denoted by 0.
So my calculation should be something like this
Is this possible to generate this
It is possible. I created a simple calculation called calc:
when null then 2
Let me know if the attached sample works for you.
Thank you so much
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...