Dynamic Aggregation and Filtering in Treemap Visualizations

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Current data visualization techniques, such as treemaps, lack flexibility in varying aggregation functions, depth level selection, and intuitive filtering, making it difficult for users to effectively analyze hierarchical data and link graphical elements to related information.

Innovation Solution

Implementing systems and methods that allow users to select and modify aggregation functions, specify visible depth levels, and filter data visualizations intuitively, while enabling linking of graphical elements to related information through string substitution and web-accessible processes.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If fixed aggregation functions are used in treemap generation, then the system complexity is reduced, but the adaptability and versatility of the visualization are limited

Engineering Contradiction:
Improveaggregation function variabilityVSAvoidsystem complexity
Core Design Contradiction:
Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The system transitions from static fixed aggregation functions to dynamic user-selectable aggregation functions. The treemap generation component now supports multiple aggregation functions (summation, count, average, minimum, maximum) that can be dynamically selected and changed by users through the interface, allowing the visualization to adapt to different analytical needs without increasing inherent system complexity.

Inventive Principle:
Principle #15Dynamics

Solution Approach 2:

The aggregation function parameter is made changeable by users. The system provides a configuration option where users can select different aggregation functions (e.g., from summation to average) to recalculate and regenerate the treemap visualization, enabling flexible data analysis while maintaining a manageable system architecture through standardized parameter control.

Inventive Principle:
Principle #35Parameter changes

2Ease of operation

If default depth levels are fixed in the visualization, then the device complexity is minimized, but the ease of operation and user control are reduced

Engineering Contradiction:
Improvedepth level selection flexibilityVSAvoidconfiguration complexity
Core Design Contradiction:
Ease of operationVSDevice complexity

Solution Approach 1:

The depth level configuration transitions from a fixed default state to a dynamic user-controllable parameter. Users can interactively adjust the depth level slider to expand or collapse hierarchical levels in the treemap, enabling flexible exploration of data at different granularities without requiring complex reconfiguration of the underlying system architecture.

Inventive Principle:
Principle #15Dynamics

3Ease of operation

If comprehensive filtering options are provided, then the ease of operation improves, but the device complexity increases

Engineering Contradiction:
Improvefiltering capabilityVSAvoidinterface complexity
Core Design Contradiction:
Ease of operationVSDevice complexity

Solution Approach 1:

The filtering functionality is extracted as a separate, dedicated component within the interface. Users can access filtering options through a distinct filter panel that allows selection of specific data dimensions and criteria, separating the filtering concern from the main treemap visualization and enabling intuitive data filtering without overwhelming the user with integrated complexity.

Inventive Principle:
Principle #2Taking out (Extraction)

4Loss of information

If multiple data dimensions are mapped to cell characteristics, then the information density increases, but the measurement precision and clarity of individual data aspects are reduced

Engineering Contradiction:
Improvedata representation completenessVSAvoiddata dimension clarity
Core Design Contradiction:
Loss of informationVSMeasurement precision

Solution Approach 1:

The data dimension mapping is segmented and organized into distinct categories (e.g., area mapping, color mapping, texture mapping). Each data dimension can be independently assigned to specific cell characteristics, and users can control which dimensions are displayed and how they are mapped, allowing comprehensive data representation while maintaining clarity through structured organization and independent control of each mapping relationship.

Inventive Principle:
Principle #1Segmentation

Data Source

PatentUS9477732B2Filtering for data visualization techniques
Publication Date: 2016.10.25 ORACLE INT CORP
  • US9477732B2 patent drawing
  • US9477732B2 patent drawing
  • US9477732B2 patent drawing

AI summary

Systems and methods in accordance with various embodiments of the present invention provide for representing data values of a data set as a plurality of graphical elements in a data visualization, where each data value is associated with a plurality of data dimensions. A first data visualization may be generated based on a first configuration of the dataset. The first data visualization and a first user interface are displayed on a data visualization display page. The first user interface includes the plurality of graphical elements in the first data visualization. A selection of a element of the plurality of graphical elements is received through the first user interface. Moreover, the data values based on the received selection are filtered. A second data visualization representing the data set excluding the filtered data values is displayed.