Export samples from an average

icuesta
icuesta
in Software Products
I need to export the average of the 4 amounts. For example, I have this Sample Set table:

SampleName    Injections    Dilution 
       
       A                   1               10              
       A                   1               10       
       A                   1                 6
       A                   1                 6                
       B                   1               10            
       B                   1               10
       B                   1                 6
       B                   1                 6

I have 4 results per each sample (2 injections/dilution). In my report I can calculate the average, but I would like to export that only result (the average). I don't have any labels assigned for them and I think I should, is that right? I don't know how many CF should I create or how to do it. 
       

Answers

  • Empower2019
    Empower2019
    Assign a Label of A for the 4 A samples and then Assign a Label of B for the 4 B Samples, and make sure A and B arent labelled anywhere else in the sample set. Create a peak, real custom field with search order Result Set Only and formula:
    SAME.%..AVE(Amount) and make sure to put Summarize Custom Fields as the last line in the sample set. 
    When you process the sample set to generate a result set, the result for the average amount of each set of samples will populate in the result set. The "SAME" part of the formula basically tells Empower to average all the amounts for samples with the same label so as long as the labels for each set of samples you want averaged are all the same, it will work. It doesnt have to be A..B etc it can be U1 for unknown 1, U2, U3 etc. 
    If you only want one particular peak averaged then you can set that peak in CCalRef1 of the processing method used to process the sample set, in which case the formula changes to:
    SAME.%..AVE(CCalRef1[Amount])
  • icuesta
    icuesta
    First at all, thank you for your answers.

    I tried it: I created a Custom Field as you said. Then I created a method (method type: Export) with Report Type "Summary By All" and in the Field Data I added my sample info and the Custom Field that I created with that formula. When I export, I select my 4 samples with same Label, but in the generated report there is no result. What am I doing wrong? 
  • Jovvor
    Jovvor
    Did you set in your sample set the "summarize custom fields" in the function tab as a line for the processing?
    Else the intersample custom fields that Empower2019 said will not be calculated.

    You will also need to create a result set (Processing from your sample set) and not singular results from injections/channels.
    Than it should work.

Categories