Applying segment conditions to measure results
View Patent ↗Techniques for applying segment conditions to measure results are presented. Row and column segment data is acquired from a database according to row and column definitions. A measure calculation is applied against the intersecting row and column segment data. Next, one or more combinations or conditions derived from the row and column definitions are used as a filter to produce filtered results.
1. A computer-implemented method to execute on a machine, comprising:
receiving, by the machine and from a user via a GUI tool, one or more row segment definitions and one or more column segment definitions, wherein each segment definition comprises one or more criteria, and wherein each segment definition defines a segment;
receiving, by the machine and from the user via the GUI tool, a measure calculation;
populating, by the machine, selectable combinations of row and column segment conditions within fields of the GUI tool;
receiving, by the machine and from the user via the GUI tool, a selection of a combination from the selectable combinations; and
applying, by the machine, the user-supplied measure calculation to filtered intersections of the one or more row segments and the one or more column segments, where each intersection comprises data relating to one or more entities contained in both a respective row segment and a respective column segment, and where the filtering is based on the user-selected combination.
2. The method of claim 1 further comprising, receiving, by the machine and from the user via the GUI tool, a grid layout definition associated with a graphical grid, wherein the graphical grid is used to present the results of applied calculation.
3. The method of claim 2 further comprising, acquiring, by the machine, data relating to each intersection by querying a database using the respective row segment and column segment definitions.
4. The method of claim 3 further comprising, sorting, by the machine, the results within the graphical grid in response to a sort order supplied by the user via the GUI tool.
5. The method of claim 4 further comprising, resorting, by the machine, the results to a different sort order in response to a dynamic instruction received from the user interacting with the graphical grid.
6. The method of claim 1 , wherein receiving the user-supplied measure further includes presenting the user via the GUI a list or a library of available measure calculations for user selection.
7. The method of claim 1 , wherein populating further includes generating the combinations as: one or more row segment conditions; one or more column segment conditions; one or more row segment conditions and one or more column segment conditions; one or more row segment conditions or one or more column segment conditions; and no row segment conditions or column segment conditions.