Level of Detail Calculation Generation for Data Visualizations

Resolve Bottlenecks,
Find Innovative Solutions
Generate 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

VSEngineering 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

Engineering Contradiction:
Improvedata aggregation controlVSAvoiduser cognitive burden
Core Design Contradiction:
Measurement precisionVSEase of operation

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.

Inventive Principle:
Principle #25Self-service

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.

Inventive Principle:
Principle #28Mechanics substitution (Replace mechanical system)

2Adaptability or versatility

If data visualization systems support multiple aggregation levels, then data analysis flexibility is improved, but system complexity and interface difficulty increase

Engineering Contradiction:
Improveaggregation level flexibilityVSAvoidsystem complexity
Core Design Contradiction:
Adaptability or versatilityVSDevice complexity

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.

Inventive Principle:
Principle #1Segmentation

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.

Inventive Principle:
Principle #17Another dimension (Dimensionality change)

3Manufacturing precision

If users directly write Level of Detail expressions, then calculation precision is improved, but time consumption and productivity decrease

Engineering Contradiction:
Improvecalculation accuracyVSAvoiddata analysis speed
Core Design Contradiction:
Manufacturing precisionVSProductivity

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.

Inventive Principle:
Principle #10Preliminary action

Data Source

PatentUS11625163B2Methods and user interfaces for generating level of detail calculations for data visualizations
Publication Date: 2023.04.11 TABLEAU SOFTWARE INC
  • US11625163B2 patent drawing
  • US11625163B2 patent drawing
  • US11625163B2 patent drawing

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.