I am trying to find an efficient/less tedious way to implement the following calculated field.
While this approach leads to the desired result, it is not ideal if the list of possible 'WHEN' cases becomes very long or the calculated field has to be implemented repeatedly.
Another issue would be if additional possible cases are added as Fields and all existing calculated fields have to be updated.
Thank you very much in advance!
You might want to try something like - Creating a Dynamic “Parameter” with a Tableau Data Blend | Drawing with Numbers as a potential solution.
And you might be interested in following this thread and related threads - https://community.tableau.com/ideas/1178
I hope this helps