Title | | » | Add some way to produce summary statistics to reports by grouping replicate annotations |
Assigned To | | » | Nick Shulman |
Type | | » | Todo |
Area | | » | Skyline |
Priority | | » | 3 |
We now have multiple places in the UI (peak areas and group comparisons) where users can group by replicate annotations. It would be ideal to have a Group By option in the report/view editor which caused all ResultsSummary fields to apply to the groups, instead of the entire document, and the groups to be listed instead of replicates. Once a grouping is applied, the Replicates and Results fields could disappear and have Replicates replaced by Groups and "Pivot Replicate Name" by "Pivot Group Name".
I know you saw this as an expression language feature with more SQL-like grouping and summary functions, but I think this direction could be more intuitive to our non-programmer users (probably the majority).
Note that the original request was for grouping and reporting on CVs of peak area for groups. To achieve this in a UI like what I have described:
1. Choose a Group By annotation
2. Find Cv Total Area and check it
3. Check identifying columns also
4. Decide whether to pivot by the grouping annotation
Exactly the report requested with very little need for the user to learn anything new beyond, "What's this Group By option?"