Level of Detail Calculation Generation for Data Visualizations
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current data visualization systems face challenges in efficiently supporting user interactions and managing multiple aggregation levels, leading to a cognitive burden on users and suboptimal human-machine interfaces.
Innovation Solution
The method generates Level of Detail (LOD) calculations through user input on a graphical user interface, allowing users to select data sources, drag-and-drop data fields, and create custom calculations, which are then aggregated and visualized, enabling efficient data analysis with intuitive operations.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Measurement precision
If users manually create and manage Level of Detail expressions for data aggregation, then data visualization accuracy and control are improved, but user cognitive burden and operational complexity increase
Solution Approach 1:
The system automatically generates Level of Detail expressions by analyzing user selections of data fields and visualization parameters. The computer identifies required aggregations and creates the appropriate LOD expressions without manual user input, allowing the system to serve itself in generating the complex computational logic needed for accurate data aggregation.
Solution Approach 2:
The patent replaces the manual mechanical process of writing and managing LOD expressions with an automated computational system. The computer analyzes data field relationships and automatically generates the computational expressions, substituting human cognitive effort with algorithmic processing that accurately handles the complexity of multi-level data aggregation.
2Adaptability or versatility
If data visualization systems support multiple aggregation levels, then data analysis flexibility is improved, but system complexity and interface difficulty increase
Solution Approach 1:
The system segments the data aggregation process into distinct levels by identifying different data fields and their hierarchical relationships. Each data field can be associated with a specific aggregation level, allowing the system to handle multiple granularity levels independently. This segmentation enables flexible multi-level aggregation without requiring the user to manage the entire aggregation hierarchy as a single complex structure.
Solution Approach 2:
The patent introduces a new dimension of aggregation level as a separate attribute that can be independently controlled for different data fields. Instead of managing complexity through nested hierarchical structures, the system adds an aggregation level dimension that allows fields to be positioned at different levels simultaneously, simplifying the interface while supporting versatile multi-level analysis.
3Manufacturing precision
If users directly write Level of Detail expressions, then calculation precision is improved, but time consumption and productivity decrease
Solution Approach 1:
The system performs preliminary analysis of data field relationships and automatically generates appropriate Level of Detail expressions before the user needs to use them. By pre-computing and pre-validating the aggregation logic based on selected data fields, the system ensures calculation accuracy is built into the generated expressions while eliminating the time users would otherwise spend writing and debugging complex LOD expressions manually.
Data Source
AI summary
A computing device displays a data visualization interface that includes a shelf region and a schema information region. The device receives user input to select a measure data field and a dimension data field from the schema information region. The device generates a custom calculation that groups data values of the dimension data field according to respective distinct data values of the dimension data field and aggregates data values of the measure data field for each of the distinct data values of the dimension data field. The device stores the custom calculation as a new selectable data field and displays the new selectable data field in the schema information region. The device receives user selection of the new selectable data field from the schema information region and placement of the new selectable data field in the shelf region. The device generates and displays a data visualization.


