Issue 515: Add some way to produce summary statistics to reports by grouping replicate annotations

issues
Status:closed
Assigned To:Guest
Type:Todo
Area:Skyline
Priority:1
Milestone:4.1
Opened:2017-05-04 08:42 by Brendan MacLean
Changed:2018-10-16 14:22 by Brendan MacLean
Resolved:2018-10-15 15:02 by Nick Shulman
Resolution:Won't Fix
Closed:2018-10-16 14:22 by Brendan MacLean
2017-05-04 08:42 Brendan MacLean
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?"

2017-06-10 06:29 Brendan MacLean
Priority3»1
Milestone»4.1
Let's really do this for 4.1. I found another request for it that is years old from another collaborator at an instrument vendor that is funding us. That makes 2.

2018-10-15 15:02 Nick Shulman
resolve as Won't Fix
Statusopen»resolved
Assigned ToNick Shulman»Brendan MacLean
Instead of doing this feature, we ended up doing a more general pivot editor.
The documentation for the Pivot Editor is here:
https://skyline.ms/_webdav/home/software/Skyline/%40wiki/new-4-1-features/SkylinePivotEditor.pptx

2018-10-16 14:22 Brendan MacLean
close
Statusresolved»closed
Assigned ToBrendan MacLean»Guest