I wanted to select Hits on basis different than the one in the Tableau example,
My way if to compute the low control mean and standard deviation and then plot the sample which are (3 * standard deviation of the low control way from low control mean)
I'm confused how to calculate first the low control mean and standard deviation -- I have the well type which contains low control and sample and high control. I want to filter the well type to low control to compute the mean and standard deviation and then compare the sample measure to these.
the question is how to filter the well type to compute the mean and standard deviation of Well type [low control] and then compare well type [sample] to these values ?
We're going to need a bit more information to be able to answer this question. Screenshots, data, and/or a packaged workbook would be helpful.
Ps. If you've found a solution please share!