Enabling visualisations from two tables in various visualizations

I would like to see improvements made to the option of creating visualisations from two different tables.

I have attached a specific example.

Initial situation: I have a table with wafers. There are measured values for each wafer. There is a second table listing the associated equipment for each wafer. These tables have a column match on wafer.

If you now create a scatter plot in which you plot the measured values over time and colour them according to equipment, this is possible without any problems if you select the column that both tables have in common and for which a column match exists (in this case, wafer) on “marker by”.
However, if you want to create a box plot in which you want to plot the test values over the equipment and colour them by equipment, this is not possible. In theory, it should be possible if you have equipment on the x-axis and color by axis, as this would allow for a clear assignment of the data.

In the example, I have also created a box plot as I would like to have it in this example. To do this, I use a join of the two tables.

This example is greatly simplified and, of course, you could simply join the tables here. However, there are more complex scenarios in which joining the tables would lead to a multiplication of rows (if you have more than one row of context information for each wafer), which is difficult to handle with complex custom expressions in the visualisations, or you would have to pivot the tables, which again creates certain disadvantages and manual effort.