I have been using the sets feature to analyze data based on standards( I use custom list for a grouping from a list creating an easy in/out reference to analyze on). This feature is very helpful, but when I join with multiple databases I cannot place a set on the sheet.
Would anyone know how to place a set on a sheet that actively has three joins on it( and three values from 3 different sheets). The set is built on the corresponding database that solely has that field.
Example of my use case:
Take if a standard is six colors like blue. I create a set saying blue is in, therefore blue is in the set. I can exclude in and identify data that says red. With multiple joins I cannot even place the Set, it becomes shaded grey.
I appreciate any help, this is my first post and I am new to the tableau community.
While this sounds like a limitations of sets, you may be able to create custom groups using another method then color code. Would you be able to provide a packaged workbook so we can take a look at the work you've done and try to find a solution?