Active3 years, 1 month ago
I frequently need to assign a placeholder value to a field when the Tableau interprets the data value as NULL. In most cases it's assigning a zero to a null value. Using a calculated field as a proxy for the real data field allows me to do this, and all I need is a way to assign the value zero (0) to the calculated field when the data value is null.
I am trying to get functionality as shown in the below SQL code:
I want to represent all the 4 cases (Add, update/Display, Update/Display All and Correction) as column values for a worksheet in tableau.
I found 'case' statement is a valid function in tableau but am not sure if i can get this kind of a functionality. Basically I am only given 'authorizedAction' and I need to create one calculated field for the 4 cases above. Can I somehow group these case statements into one calculated field formula?
Any help is appreciated. If you can provide me a calculated field formula that works, nothing like it!
CarbonD1225CarbonD12253014 gold badges16 silver badges34 bronze badges
1 Answer
In the SQL statement above, you have a single input field that gets split into 4 output fields, each of which may be 'Y' or blank. You can create a similar set of 4 calculated fields in Tableau, each one with a formula, along the lines of
HellionHellion