Hierarchical Grouping Columns in Data Tables
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
When users manipulate the grouping of columns in tables, the hierarchy order is often lost, leading to a disruption in the organization and visibility of relationships within the data set.
Innovation Solution
A system and process that automatically reestablishes the column hierarchy order by analyzing the number of groupings in each column and reordering them based on this information, with the ability to save and restore the original order when necessary.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If a user ungroups a highly grouped column, then the user has flexibility to manipulate data, but the hierarchy displayed by the ordering of the table columns is lost
Solution Approach 1:
The system performs preliminary actions by automatically detecting grouping changes and reordering columns before the user can observe the loss of hierarchy. When a column is ungrouped, the system proactively reorders all columns to restore hierarchical order, preventing the hierarchy information from being lost in the user's view.
Solution Approach 2:
The system implements feedback by continuously monitoring grouping operations and automatically adjusting column order in response. When a user ungroups or groups a column, the system detects this change and responds by reordering columns to maintain hierarchy, creating a closed-loop system that preserves hierarchical information despite user manipulations.
2Reliability
If the system automatically reorders columns to maintain hierarchy, then the hierarchy is preserved, but the device complexity increases
Solution Approach 1:
The system performs self-service by automatically detecting grouping changes and reordering columns without requiring external intervention or complex control mechanisms. The system monitors its own state (grouping operations) and autonomously adjusts the column order, reducing the need for additional complexity in user interface controls or backend processing.
Solution Approach 2:
The system changes the parameter of column order dynamically based on grouping operations. By automatically adjusting the order parameter in response to grouping changes, the system maintains hierarchy reliability through a simple parameter adjustment mechanism rather than complex structural changes.
3Reliability
If the system reorders columns frequently in response to user changes, then the hierarchy is maintained, but the processing time increases
Solution Approach 1:
The system implements periodic action by triggering column reordering only at specific moments when grouping operations occur, rather than continuously monitoring and adjusting. This event-driven approach maintains hierarchy consistency while minimizing processing time by acting only when necessary.
Solution Approach 2:
The system rushes through the reordering process by performing it as a quick automatic operation in response to grouping changes. The reordering is executed efficiently without unnecessary delays or intermediate steps, maintaining hierarchy consistency while minimizing the time penalty for each operation.
Data Source
AI summary
A system and process that automatically responds to changes in displayed table data to determine and reestablish a hierarchy for the table. A column hierarchy order component checks each column of a table to determine the number of groupings of entries and reorders the columns based on the number of groupings. A column order at the time a table is loaded is saved and can be used to restore that original order.