I have a large database which is formed of multiple experiments which can be separated by the scale of the experiment. I have created a scatter graph in graph builder with scale on the x-axis (a nominal variable with two values) and yield on the y-axis (continuous) with a overlay of experiment (as each experiment has repeats so there are multiple of each). Is there a way to add a summary statistics of mean with error bars of standard deviation for each scale (so one line for the small scale and one for the larger scale)? I tried before but loads of lines appeared because it presented the summary stats for each experiment and its repeats individually.
Additionally, I have a column switcher to change the y-axis to the other variables I have measured and would want the mean/SD statistic to still be present and update depending on my current column selected.
Is there a way to do this? Thank you in advance.
