3D Pivot Table Rendering for Multi-Angle Data Editing
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing data visualization tools, such as pivot tables, lack the ability to provide a comprehensive, interactive, and intuitive three-dimensional representation of data, limiting user interaction and analysis capabilities.
Innovation Solution
A system and method for rendering and manipulating three-dimensional pivot tables, allowing users to interact with and manipulate 3D pivot tables through a graphical user interface, enabling slicing, scrolling, and editing of data from multiple perspectives.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If a two-dimensional pivot table is used to display data, then the data can be summarized and aggregated, but the user cannot access interior cell values and is limited to viewing data from a single perspective
Solution Approach 1:
The patent transforms the traditional two-dimensional pivot table into a three-dimensional cube structure, adding a vertical dimension that allows users to access interior cell values. This dimensional change enables viewing data from multiple perspectives (top, bottom, left, right faces) while maintaining the aggregated data structure, thereby improving adaptability without excessively increasing complexity.
Solution Approach 2:
The three-dimensional cube is divided into multiple faces, each representing a different perspective or aggregation view. Users can selectively access different faces or slices of the cube to view specific data perspectives, which segments the complex 3D structure into manageable 2D-like views while preserving the enhanced functionality.
2Adaptability or versatility
If a three-dimensional pivot table is rendered to provide comprehensive data representation, then users can visualize data from multiple angles, but the system complexity and rendering requirements increase
Solution Approach 1:
By adding a third dimension to the traditional 2D pivot table, the system enables multi-angle data visualization. The cube structure allows users to rotate and view data from different perspectives, significantly enhancing visualization capability while the systematic approach to 3D rendering manages the added complexity through structured algorithms.
3Ease of operation
If users can access and manipulate all cell values including interior values, then data analysis capability is enhanced, but the user interface complexity increases
Solution Approach 1:
The interface is segmented to present data through multiple accessible faces of the 3D cube, each face representing a manageable 2D-like view. Users can interact with individual faces or slices as needed, which simplifies the interface structure while maintaining comprehensive data manipulation capability across all cell values including interior values.
Data Source
AI summary
Described are systems and methods for rendering a three-dimensional (3D) pivot table that can be embedded in a spreadsheet. A data structure underlying the 3D pivot table contains raw data organized in arrays that can be depicted as two-dimensional (2D) tables. A rendering system combines some or all of the 2D tables into a 3D rendering of a pivot table in which each of the combined sides represents a visible face of the 3D pivot table. A user can split the rendered 3D pivot table along one or three axes to expose internal data elements for viewing or editing. Changes to the values of internal data elements impact values presented in the visible faces of the 3D pivot table.