CellProfiler/CellProfiler — Issue #211: JIRA [IMG-506] Allow ExportToDatabase to group data by any metadata
Author: thouis
Created: 2011-11-23 20:50:39+00:00
State: open

Currently, per-image and per-well means/medians/standard deviations can be exported via explicit questions. This should probably be made more flexible such that data can be grouped by any other metadata. At the same time, we should consider whether the settings should be made heirarchical, like"Select population statistics to be exported" (dropdown menu = per-image, per-well, etc, with the menu populated based on what metadata has been extracted elsewhere in the pipeline if possible, or perhaps an edit box to type in if it's not feasible to extract it). Then an option to"Add another population statistic" with the same menu. When one of those is chosen, several other checkboxes appear: Calculate mean values? Calculate median values? Calculate st dev values?

Original reporter: anne
Jira link: https://jira.broadinstitute.org/browse/IMG-506
Assignee: afraser

**Comment from ljosa on Fri, 18 Jun 2010 10:55:24 -0400:**
May require changing the database schema, or at least storing the aggregate measurements in a new table. For instance, per-well aggregates should be stored in a per_Well table. Maybe—I haven't thought much about it.