Hi!
I am using 14.1.0.
I contacted the support team - and apperently it wasn´t a one-click fix.
Here is the answer I got (I had 3 columns, A, B and C (%))
---
Click Tables -> Stack
Select B (%), A (%), and C (%) and click Stack Columns
I named the Stacked Data Column Data Left, but this is optional.
Next we need to reformat the new data set
In the dataset that opens from the stack create a new column called Data Right
Copy the values from Data Left into Data Right
Now for the left axis we ONLY want to include the rows from A (%), and the right axis we want ONLY B (%) and C (%)
To do this I chose Rows -> Data Filter
Then Select Label and click Add
Choose A (%)
Click on the Data Right Column and press delete - thereby deleting the A (%) values from Data Right, and leaving ONLY B (%) and C (%).
Return to the data filter
This time select B (%) and C (%).
Click on the Data Left Column and press delete - thereby deleting B (%) and C (%) values and leaving ONLY the A (%) values.
Finally create the graph
Click on Graph -> Graph builder
Drag Data Left and Data Right to the Y axis
Drag Sample Name to the X axis
Drag Label to Overlay
Change points to bar
Right click on the Y axis and choose Move Right -> Data Right
---
But this makes scripting a little harder now (I am trying to streamline scripts so my team can use it for their databases).
I can only find the script when the new dataset comes up, which is:
Data Table( "Test for JMP" ) << Stack(
columns( :Name( "B (%)" ), :Name( "A (%)" ), :Name( "C (%)" ) ),
Source Label Column( "Label" ),
Stacked Data Column( "Data Left" )
);
But when I do the additional steps (adding column and the data filtering) – I can´t find the script for that.
I only get the script out of Graph Builder – but that is only for the graph (not how you got there).