Welcome to Forums.
Please see if the attached could be a starting point for you.
As this method employs joining the dataset to itself, I'm not sure if
it will be tractable for your full dataset. (The attached twbx seems to
take an inordinately long time to load. Maybe best to recreate using
the attached xlsx and pictures of pill arrangement.)
Firstly, I'm not sure if this was in your original data, but I added a number
to each row, in the attached called [Row].
Then I pivoted the dataset such that it was now arranged as:
[Row], [SetName], [SetValue].
I did it using the Tableau Add-in in Excel (what is your datasource?).
Then I connected to that table and joined it to itself, using the [Row]
as the Key (please see Figure 1 below). This creates all the pairs
of values that are in the same [Row].
Then the pills were placed as shown in Figure 2 below.
One [SetName] on Columns, the 2nd one on Rows.
Likewise with the Values.
Then both [SetName] and [SetName (Sheet 1-Tableau)]
were placed on the Filter shelf.
-Each axis has a separate filter control.
-the SetName labels for the x-axis are on the top
while the SetValue labels are on the bottom
The pivoting should be fine. (In the long run, I am using a Netezza database. This excel file is just for testing purposes.)
Joining the dataset to itself will likely be too costly though, as the dataset that I am using in the long run will actually be much larger than the test dataset that I am using here.
It does seem like a good starting point though, thank you very much.
Here is another approach, but it is suboptimal in many respects.
But maybe it can give other ideas.
This uses the dataset in its original wide format.
Basically it uses boolean parameters to tell whether to show,
and a calculated field that only populates if parameter is true.
-It requires a parameter for each set.
-User has to toggle the boolean parameter for each desired set
-Place holders for all the sets show all the time, only get populated when boolean set parameter is true
Another thing that I was looking into was data scaffolding.
There may also be some possibilities with a Panel/Trellis chart:
211779pair2.twbx 667.8 KB
I had also played around with calculated fields, unfortunately part of the parameter for each set as well as the fact that it doesn't actually hide the charting area, just the data, which made me think that it wouldn't really work if the viewer wanted to view two sets in detail.
I can also look some into data scaffolding to see if it could be helpful.