Background subtraction

Flow Forum (Inactive)
Background subtraction awilson  2010-07-06 11:10
Status: Closed
 
Hello,

Is there a good sql script to be able to subtract a particular row from a series of other rows? I would like to subtract a mock/background row from several other test rows based upon participantId, visitid or date, cohort etc.

any recommedations.
 
 
kevink responded:  2010-07-06 15:28
Is this a flow run? We do have some basic background subtraction built in to flow.

From the flow overview page, click [other settings], then click [Edit ICS Metadata]. On this page, you must supply two bits of information: (1) a value that matches for both foreground and background (e.g., the experiment run), and (2) a column and value to identify which rows are background. If multiple wells match the background, the background value will be the average of the background wells.

Once you've identified the "ICS Metadata" you'll be able to add the background values for any statistic in a flow grid views using "Customize View." Unfortunately, we don't do the subtraction of the foreground from the background automatically yet. You'll need to write a custom query to do that. I can help out writing the query.
 
awilson responded:  2010-08-19 13:16
sorry for the late reply. this is list data and would there for require some sql code for it. we can take the discussion offline if you want to show me how to do it.

aaron