Overlay a common "control" dataset over grouped datasets
Aug 6, 2020 1:32 PM
| Last Modified: Aug 6, 2020 1:33 PM(302 views)
Hi there. I have data that has 2 factors: salt and salt's concentration. With 4 salts and 4 concentration levels, that results in 16 unique sets of data. There is a "0 concentration" that is the control - no salt, and no salt concentration.
Currently: I'm using Graph Builder and Overlaying the concentration levels (like a dose response over time) and grouping by salt type - all in 1 graph. But right now, since I'm grouping by salt, the 0-concentration shows up as a separate sub-graph with 1 trace (0 concentration) and is not overlaid with the others (it's called "No Salt" in the "Salt" column). The other salts' sub-graphs have 4 traces each (one for each concentration level).
Want to avoid: I want to avoid copying the control data 4 times and changing the "Salt" column entry to each of the four salts. Also, I want to avoid using "Copy Frame Contents" and pasting into each salt sub-graph.
Target: How can I plot the control "0 concentration" on each salt plot automatically?
Hi, Is your data stacked? If it is not (i.e. split in multiple columns) you may want to stack the data with the option of keeping all other variables. If it is already stacked, could share an example of the data layout and the Graph Builder output? Best, TS
And the 5th panel only has 1 trace - the control (0 salt). I want to overlay the 0 salt with the other 4 panels (which are 4 different salts with various concentrations of salt) without replicating the data.
Hi, I now better understand your issue. I don't think that the tip I gave you re: stacking the data will produce what you need. I have to admit that without replicating the control data, I'm not sure that there is an easy solution. Let's see if other JMP Community members think. Best, Thierry