I am new to Tableau and need to create calculative fields. Can Some one help me to create conditional statements in Tableau. Requirements along with data set is attached with required columns.
Your requirement is very similar to this post.
Tableau Lookup based on if else conditions
The solution is similar too.
Create a flag indication if DESC1, DESC2, DESC3 is null or not null.
Then use LOD to aggregate to site, number, name.
Overview: Level of Detail Expressions
Retrieving data ...