My data table has several columns of the same data type (but different test runs). The reason for not having the same data always in the same column is that I would like to be able to create new columns (e.g. "change from run1 to run2" = run2 - run1) and also plot those in graph builder. The number of columns of similar data type is dynamic (because the user can select how many runs to compare).
I would like to have the option to create a box plot based on the data coming from several columns. Is this possible? If so, how?
If I add another variable to the y-axis, an additional box lot is created and the data is not merged.
Any suggestion for workaround in my workflow is also highly appreciated.
What you need to do is to simply create a new data table where the columns you want to combine are stacked into a new column. To do this, use
I do not see a way to do what you want within one Graph Builder instance. However, if I had the requirement to do what you want, JMP, using a script, could produce the 2 graphs you want, and then take the parts from the graphs and bring then together into a final display.
maybe another user has a better insight on how to use a single Graph Builder to do what you want?