I'm trying to filter a report on a condition where dimension 1 <> dimension 2. This is really easy in SQL but I'm not entirely sure how to go about it in Tableau.
I guess I could do a calculated column called "Comparison" where I do If dimension 1 <> dimension 2 'True' else 'False end and filter that on True. But that seems a little convoluted.
Is there a more straightforward way to accomplish htis?
Joe, unless I'm misunderstanding, you won't need a 'Comparison' column. Just create a calculated field like this:
[Dim1] <> [Dim2]
Then put this on the filter shelf and set it to true or false, which ever you need.