question about grouping in report template/ intelligent reporting in Open Lab CDS 2.5

Hello

I have a question about grouping in the report template/intelligent reporting in Open Lab CDS 2.5. (what is the difference?)

I am currently working on grouping three different injections of the same sample. The grouping parameters i have currently set to this: =IF(Compound_Name = "" , round(Peak_RetentionTime,2)   , Compound_Name )
This works perfectly for my named peaks, however when an unknown has a retention time of 0.01 more or less in one of the injections, they are obviously not grouped. How can i change my formula to include RT +/- 0.01


Parents
  • Hi, I'm interested to find out more. What does the report looks like if you remove the IF statement you are using for the grouping parameters? I'm not sure that the IF statement you are using is doing what you think it is. Did you create the table from scratch or is it from an Agilent report?

    Regards

  • Hi

    If i remove the IF statement and put nothing in it's place there is obviously no grouping... Well there is, but the entire table is 1 group. (as seen by the average on the end)

    If i group on compound name, i only get the named compounds grouped seperately, and all the unknowns together

    If i only filter on retention time (rounded to 2 decimals), i have the same problem as before, but also with my known compounds. There cannot be a 0,01 difference in RT. 

    Therefore, the IF statement makes sure that when i have a compound name, it groups on compound name. If there is no compound name, it groups on RT.
    I could make my RT rounded to 1 decimal, but that raises other issues.

    1) 2 peaks cannot fall too close to each other, or they would be grouped. although since evere 0,1 minute is 6 seconds, this issue might not occur...
    2) if RT on a peak is x,54 in one injection and x,55 in another, they would still not be grouped. This might also not occur, but I would still prefer a foolproof solution.  

    As to answer

    The table is built from scratch. I have it in a composite group that filters on sample type and repeats on sample name like this:

    This way all 3 injections of the same sample are in the same table. However since every known and unknown peak needs to be averaged out, i thought the grouping would be nice.

    the table right now is just sample name - compound name - retention time - RRT (calculated with a variable of the main compound, made in an invisible table) - RRF (IF statement to make it 1,04 for 1 specific peak, else 1,00) - peak area 

    Hope this is enough info Slight smile

    kind regards

  • Thanks for the thorough explanation! I have given it alot of thought but unfortunately, i too am at a loss as to how to achieve a group from 3 different injections (of the same sample) using a  RT +/- 0.01 criteria.

    Hopefully someone else can help.

    Regards

Reply Children
  • A possible approach is to create a separate table for the unknown peaks by selecting the Unknown Peaks checkbox on the Peaks and Repeating tab, and then use 2 filters on the Filters tab to only show peaks with a +/- 0.01 retention variation to the expected. eg. with an expected rt of 15.38mins the filters would be >=15.37 and <=15.39. You would need to create the unknown peaks table for each of the 3 expected unknowns to be able to adjust the filters according to the expected rt.  This may not be the solution you are looking for but its worth considering as it would report out the average of each of the unknowns across the 3 replicate injections. For Grouping, i used a Group Repeat using Injection Sample Label whereby all reps of the same sample were assigned a unique sample label in the Injection List. 

    Regards

Was this helpful?