When you say the files are linked, it looks like you're using blending, correct? If so, that means you're effectively joining all records from one file, to the second file on certain criteria.
I think you'd be better off considering a Union statement where you stack your data ontop of each other to create one file - Combine Your Data with Union in Tableau 9.3 | Tableau Software
1 of 1 people found this helpful
I'm not sure of your exact situation but I tried to recreate the it. Can you:
- bring in another pill for count(physicians)
- set it to color
- convert it to discrete
- right click the nulls in the color legend, and select "hide"
- set the count(physician) pill back to details to get rid of the discrete colors
Attached a sample workbook and screen recording of me doing this.
Perfect! Additional question: I would like to set up multiple quick filters, one from each data source. It's only letting me set one up from one source or the other, but not both. Can this be done, or should I take my winnings and not push my luck?
Thanks Tom. Sadly, we are only on 9.1.
I'm not exactly sure what you're trying to accomplish. On the package I attached can you do it? It seemed to easily let me drag data fields from different sources into the filter pane.
If you're trying to filter on the fields separately for each "axis" (e.g. filter out zip code 90022 for one calc and 90034 for another), then I'm not sure if that's possible.
If you have no further questions, will you please mark the answer as correct and close the thread?