Thanks for your reply, Dan. I changed my table and the text after that, to make it a bit clearer. I tried to do what you said, but when I add the filter I can't find the Column Switcher that you are referring to. Also, when I add the filter, I don't get any point on the plots, since I don't have any reading for P1s at those S3s. Also, I added a sample file with a description of what I'm looking for.
... View more
Hi all, I have data for some batches and each batch has different streams(so in each row I have different parameters for a specific stream in a batch). I want to find parameters affecting, say yield, of a specific stream in all batches. It seems that this task is not straight forward. One way that my friend (@ressel) showed was extracting data for that specific stream using Data Filter in a new table and then do the job. Anyone else has an idea? Just to be sure that I have described what I want, here is an illustration of my data in the tables P1 P2 P3 P4 Y B1 S1 x x x x x B1 S2 x x x x x B1 S3 - - - - x B2 S1 x x x x - B2 S2 x x x x x B2 S3 - - - - x What I'm looking for here, is to see the effect of P1s in S1s and P2s in S2s on Ys in S3s. Here, if I select S1s and S2s, I will get the Ys that I'm not interested in, if I select S3s, I will not have access to the P1s and P2s in the location that I want. PS: I added a sample file for what I'm looking for: Evaluate the effect of milling time in streams 1, 3 and 5 and also washing time in streams 2 and 4 on Protein Yield in Streams 8 and make a model and calculate its parameters and their significance
... View more