1. grit42 Knowledge Base
  2. NEW....Project data overviews (SAR++)

Adding Setups & results to projects

This will help you understand how to add the Setups (assays/models) to your project and display the relevant results and meta data

Adding setups and results

  1. Go to the project’s “Data” tab
  2. In the top right corner click the “pencil” “Edit Project” button and select the “Setups” item

  1. Select the Setup to add in the list on the left
  2. In the dialog, configure the setup for the project and click “Add”
    1. Name: the setup can have a “project name”, this is the name that will be displayed in this particular project
    2. Project Setup Status: the setup status
    3. Sort: optional, configures the position this setup should have in the grid
    4. Description: an optional description of the setup for this project
  3. Click the “Add Project Parameter” button 
  4. In the dialog, select the parameter, configure it and click “Add”
    1. Name: the parameter can have a “project name”, this is the name that will be displayed in this particular project
    2. Aggregate Method: controls how the data will be aggregated if there are many results for the Compound/Batch, see Aggregation methods
    3. Sort: optional, configures the position this parameter should have in the grid
    4. Pivots: optional, select the Result Set Constant parameters to use for splitting the column, see Splitting results based off constant experiment parameters
  5. Repeat steps 5 and 6 for results from the same setup, or close the dialog and repeat steps 3 to 6 for results from other setups
  6. Click the “✓” “Done” button in the top right corner to return to the Project grid

A Project Setup and its Parameters can be modified by opening the Setups configuration and selecting it in the list on the right.

Setup requirements

For a Setup to be eligible for use in a Project, it needs to meet the following requirements:

  • The Setup must have a Result Parameter of Type “Compound” and Experimental Role “Independent Variable”
  • The Setup must be published

Setups that do not meet these requirements will not be shown in the “Available Setups” list.

Aggregation methods

In case a Compound has more than one result for a given Setup Parameter, the results must be aggregated in some way to be displayed in one cell of the Project grid. The aggregation method used can be configured when editing a Setup Parameter in a Project. Available aggregation methods vary based on the Type of the Parameter:

  • Numeric parameters:
    • Average: the average of all results
    • Minimum: the lowest value of all results
    • Maximum: the highest value of all results
    • Latest: the value that was updated the latest
  • Boolean parameters:
    • AND: true if all values are true, false otherwise
    • OR: true if some or all values are true, false otherwise
    • Latest: the value that was updated the latest
  • All other parameter types:
    • Comma separated: all values are shown, separated by commas
    • Latest: the value that was updated the latest

Splitting results based off constant experiment parameters 

If a setup has Result Parameters of Experimental Role “Result Set Constant”, the values of these parameters can be used to split a Project Setup Parameter over multiple columns (such parameters are referred to as “Pivots”), as many as there are different combinations of values for the selected Parameters.

For instance, given a Setup with two Parameters of Experimental Role “Result Set Constant”, “Species” and “StudyID”, two Result Parameters of Experimental Role “Independent Variable”, “Compound” and “Response”, and three Experiments with the following values:

  • Experiment 1
    • Species: Rats
    • StudyID: 4242
  • Experiment 2
    • Species: Mice
    • StudyID: 4242
  • Experiment 3
    • Species: Rats
    • StudyID: 4284

Selecting the “Species” parameter as a pivot for the “Response” parameter would yield two columns, “Response Rats” and “Response Mice”, whereas selecting both “Species” and “StudyID” would yield three columns, “Response Rats 4242”, “Response Mice 4242” and “Response Rats 4284”.