Digital processing systems and methods for graphical interface for aggregating and dissociating data from multiple tables in collaborative work systems
Systems, methods, and computer-readable media for graphically aggregating data from a plurality of distinct tables, and enabling dissociation of underlying aggregated data from the associated distinct tables are disclosed. The systems and methods may involve maintaining the plurality of distinct tables, wherein each distinct table contains a plurality of items, with each item being made up of a plurality of cells categorized by category indicators, and wherein the plurality of distinct tables contain a common category indicator; generating a graphical representation of a plurality of variables within the plurality of cells associated with the common category indicator, the graphical representation including a plurality of sub-portions, each sub-portion representing a differing variable of the common category indicator; receiving a selection of a sub-portion of the graphical representation; performing a look-up across the plurality of distinct tables for a specific variable associated with the received selection.
1. A system for graphically aggregating data from a plurality of distinct tables, and enabling dissociation of underlying aggregated data from the associated distinct tables, the system comprising:
at least one processor configured to:
maintain the plurality of distinct tables within at least one database, wherein each distinct table contains a plurality of items, with each item being made up of a plurality of cells categorized by category indicators, and wherein the plurality of distinct tables contain a common category indicator;
generate a graphical representation of a plurality of variables within the plurality of cells associated with the common category indicator, the graphical representation including a plurality of sub-portions, each sub-portion representing a differing variable of the common category indicator;
receive a selection of a sub-portion of the graphical representation;
in response to the selection, perform a look-up across the plurality of distinct tables for particular items having a specific variable associated with the received selection; and
based on the look-up, cause an aggregated display of the particular items having the specific variable, wherein the aggregated display is dissociated from the plurality of distinct tables, and wherein each of the particular items of the aggregated display include the specific variable and variables associated with additional category indicators.
2. The system of claim 1 , wherein the aggregated display includes a new table different from each of the plurality of distinct tables.
3. The system of claim 2 , wherein the aggregated display includes a graphical indicator based on a percentage makeup of a characteristic of the plurality of items.
4. The system of claim 1 , wherein the at least one processor is configured to receive a sub-selection of the plurality of distinct tables for exclusion from the aggregated display, and wherein following the received sub-selection, the aggregated display is caused to change to omit items from the excluded tables.
5. The system of claim 1 , wherein the at least one processor is configured to receive selections of multiple sub-portions of the graphical display and to perform a look-up across the plurality of distinct tables for particular items having specific variables associated with the received selections.
6. The system of claim 5 , wherein the at least one processor is configured to store the selections as a template.
7. The system of claim 1 , wherein the at least one processor is further configured to receive a selection to alter one of the particular items of the aggregated display; and
in response to the selection to alter one of the particular items, output a display signal to re-render the aggregated display of the particular items.
8. The system of claim 1 , wherein the at least one processor is further configured to receive a category indicator selection; and
in response thereto, update the plurality of sub-portions, wherein the updated sub-portions represent the differing variables of the category indicator selection.
9. The system of claim 1 , wherein the at least one database comprises a plurality of databases.
10. A non-transitory computer readable medium containing instructions that when executed by at least one processor, cause the at least one processor to perform operations for graphically aggregating data from a plurality of distinct tables, and enabling dissociation of underlying aggregated data from the associated distinct tables, the operations comprising:
maintaining the plurality of distinct tables within at least one database, wherein each distinct table contains a plurality of items, with each item being made up of a plurality of cells categorized by category indicators, and wherein the plurality of distinct tables contain a common category indicator;
generating a graphical representation of a plurality of variables within the plurality of cells associated with the common category indicator, the graphical representation including a plurality of sub-portions, each sub-portion representing a differing variable of the common category indicator;
receiving a selection of a sub-portion of the graphical representation;
in response to the selection, performing a look-up across the plurality of distinct tables for particular items having a specific variable associated with the received selection; and
based on the look-up, causing an aggregated display of the particular items having the specific variable, wherein the aggregated display is dissociated from the plurality of distinct tables, and wherein each of the particular items include the specific variable and variables associated with additional category indicators.
11. The non-transitory computer readable medium of claim 10 , wherein the aggregated display includes a new table different from each of the plurality of distinct tables.
12. The non-transitory computer readable medium of claim 11 , wherein the aggregated display includes a graphical indicator based on a percentage makeup of a characteristic of the plurality of items.
13. The non-transitory computer readable medium of claim 10 , wherein the operations further comprise receiving a sub-selection of the plurality of distinct tables for exclusion from the aggregated display, and wherein following the received sub-selection, the aggregated display is caused to change to omit items from the excluded tables.
14. The non-transitory computer readable medium of claim 10 , wherein the operations further comprise receiving selections of multiple sub-portions of the graphical display and to perform a look-up across the plurality of distinct tables for particular items having specific variables associated with the received selections.
15. The non-transitory computer readable medium of claim 14 , wherein the operations further comprise storing the selections as a template.
16. The non-transitory computer readable medium of claim 10 , wherein the operations further comprise receiving a selection to alter one of the particular items of the aggregated display; and
in response to the selection to alter one of the particular items, outputting a display signal to re-render the aggregated display of the particular items.
17. A method for graphically aggregating data from a plurality of distinct tables, and enabling dissociation of underlying aggregated data from the associated distinct tables, the method comprising:
maintaining the plurality of distinct tables within at least one database, wherein each distinct table contains a plurality of items, with each item being made up of a plurality of cells categorized by category indicators, and wherein the plurality of distinct tables contain a common category indicator;
generating a graphical representation of a plurality of variables within the plurality of cells associated with the common category indicator, the graphical representation including a plurality of sub-portions, each sub-portion representing a differing variable of the common category indicator;
receiving a selection of a sub-portion of the graphical representation;
in response to the selection, performing a look-up across the plurality of distinct tables for particular items having a specific variable associated with the received selection; and
based on the look-up, causing an aggregated display of the particular items having the specific variable, wherein the aggregated display is dissociated from the plurality of distinct tables, and wherein each of the particular items include the specific variable and variables associated with additional category indicators.
18. The method of claim 17 , wherein the aggregated display includes a new table different from each of the plurality of distinct tables.
19. The method of claim 17 , wherein the method further comprises receiving a sub-selection of the plurality of distinct tables for exclusion from the aggregated display, and wherein following the received sub-selection, the aggregated display is caused to change to omit items from the excluded tables.
20. The method of claim 17 , wherein the method further comprises receiving selections of multiple sub-portions of the graphical display and to perform a look-up across the plurality of distinct tables for particular items having specific variables associated with the received selections.
21. The method of claim 20 , wherein the method further comprises storing the selections as a template.
22. The method of claim 17 , wherein the method further comprises receiving a selection to alter one of the particular items of the aggregated display; and
in response to the selection to alter one of the particular items, outputting a display signal to re-render the aggregated display of the particular items.