Using an object model to view data associated with data marks in a data visualization

Patent metadata

Field	Value
Publication number	US-12189664-B2
Application number	US-202318108549-A
Country	US
Kind code	B2
Filing date	Feb 10, 2023
Priority date	Nov 12, 2019
Publication date	Jan 7, 2025
Grant date	Jan 7, 2025

Abstract

A computing device generates and displays a data visualization in a data visualization user interface. The data visualization includes a plurality of visual data marks representing data from a data source. The computing device detects a first user input to select a visual data mark of the plurality of visual data marks. In response to detecting the first user input, the computing device identifies a first aggregated data value, for the visual data mark, corresponding to a first data field in the data source. The computing device retrieves a first disaggregated set of data rows corresponding to the first aggregated data value, from a first table, in the data source, containing the first data field. The computing device displays, in the data visualization user interface, a plurality of data rows from the first disaggregated set of data rows.

First claim

What is claimed is:

1. A method of displaying data associated with data marks in data visualizations, comprising:
at a computing device having one or more processors and memory storing one or more programs configured for execution by the one or more processors:
generating and displaying a data visualization in a data visualization user interface, wherein the data visualization includes a plurality of visual data marks representing data from a data source:
detecting a first user input to select a visual data mark of the plurality of visual data marks that is displayed on the data visualization; and
in response to detecting the first user input to select the visual data mark that is displayed on the data visualization:
identifying a first aggregated data value for the selected visual data mark, corresponding to a first data field in the data source:
retrieving a first disaggregated set of data rows corresponding to the first aggregated data value, from a first table, in the data source, containing the first data field; and
displaying, in the data visualization user interface, a plurality of first data rows from the first disaggregated set of data rows.

2. The method of claim 1 , further comprising:
in response to detecting the first user input:
identifying a second aggregated data value, for the selected visual data mark, corresponding to a second data field in the data source, distinct from the first data field:
retrieving a second disaggregated set of data rows corresponding to the second aggregated data value, from a second table, in the data source, containing the second data field; and
displaying, in the data visualization user interface, a plurality of second data rows from the second disaggregated set of data rows.

3. The method of claim 2 , wherein:
the plurality of first data rows is displayed in a first tab of the data visualization user interface; and
the plurality of second data rows is displayed in a second tab of the data visualization user interface, distinct from the first tab.

4. The method of claim 3 , further comprising:
displaying, in the data visualization user interface, a summary of aggregated data for data fields of the data visualization, the summary of aggregated data including the first aggregated data value and the second aggregated data value.

5. The method of claim 4 , wherein:
the summary of aggregated data is displayed in a summary tab of the data visualization user interface, distinct from the first and second tabs.

6. The method of claim 1 , further comprising:
in response to detecting the first user input:
obtaining a data model encoding the data source as a plurality of logical tables, wherein: (i) each of the plurality of logical tables has its own physical representation and includes a respective one or more logical fields, (ii) each of the respective one or more logical fields corresponds to either a data field or a calculation that spans one or more logical tables of the plurality of logical tables, and (iii) the first aggregated data value corresponds to a first data field in the data model.

7. The method of claim 6 , further comprising:
identifying one or more components of the data model corresponding to the selected visual data mark:
generating a query map that maps the one or more components to logical queries:
obtaining one or more tables by executing logical queries in the query map; and
generating and displaying a data flow diagram corresponding to the selected visual data mark based on the one or more tables.

8. The method of claim 7 , wherein the data flow diagram includes one or more icons that progressively disclose details of the visual data mark in response to detecting one or more user inputs.

9. The method of claim 7 , wherein the data flow diagram includes a first icon representing the visual data mark, and a second one or more icons representing the one or more tables.

10. The method of claim 9 , wherein the data flow diagram further includes a third one or more icons representing one or more groupings of the one or more tables.

11. The method of claim 10 , wherein the data flow diagram further includes a fourth one or more icons representing one or more operations corresponding to the one or more groupings.

12. A computing device for displaying data associated with data marks in data visualizations, comprising:
a display:
one or more processors; and
memory:
wherein the memory stores one or more programs configured for execution by the one or more processors, and the one or more programs comprise instructions for:
generating and displaying a data visualization in a data visualization user interface, wherein the data visualization includes a plurality of visual data marks representing data from a data source:
detecting a first user input to select a visual data mark of the plurality of visual data marks that is displayed on the data visualization; and
in response to detecting the first user input to select the visual data mark that is displayed on the data visualization:
identifying a first aggregated data value for the selected visual data mark, corresponding to a first data field in the data source:
retrieving a first disaggregated set of data rows corresponding to the first aggregated data value, from a first table, in the data source, containing the first data field; and
displaying, in the data visualization user interface, a plurality of data rows from the first disaggregated set of data rows.

13. The computing device of claim 12 , wherein the one or more programs further comprise instructions for:
in response to detecting the first user input:
obtaining a data model encoding the data source as a plurality of logical tables, wherein: (i) each of the plurality of logical tables has its own physical representation and includes a respective one or more logical fields, (ii) each of the respective one or more logical fields corresponds to either a data field or a calculation that spans one or more logical tables of the plurality of logical tables, and (iii) the first aggregated data value corresponds to a first data field in the data model.

14. The computing device of claim 13 , wherein the one or more programs further comprise instructions for:
identifying one or more components of the data model corresponding to the visual data mark:
generating a query map that maps the one or more components to logical queries:
obtaining one or more tables by executing logical queries in the query map; and
generating and displaying a data flow diagram corresponding to the visual data mark based on the one or more tables.

15. The computing device of claim 14 , wherein the data flow diagram includes one or more icons that progressively disclose details of the visual data mark in response to detecting one or more user inputs.

16. A non-transitory computer readable storage medium storing one or more programs configured for execution by a computing device having a display, one or more processors, and memory, the one or more programs comprising instructions for:
generating and displaying a data visualization in a data visualization user interface, wherein the data visualization includes a plurality of visual data marks representing data from a data source:
detecting a first user input to select a visual data mark of the plurality of visual data marks that is displayed on the data visualization; and
in response to detecting the first user input to select the visual data mark that is displayed on the data visualization:
identifying a first aggregated data value for the selected visual data mark, corre

Assignees

• Tableau Software Llc

Inventors

• Pace David
• Nhan Thomas
• Booth Jr Jeffrey Mark

Classifications

• G06F16/2282 Primary

  Tablespace storage structures; Management thereof · CPC title

• G06F16/244

  Grouping and aggregation · CPC title

• G06F16/2445

  Data retrieval commands; View definitions · CPC title

• G06F16/248

  Presentation of query results · CPC title

• G06F16/287 Primary

  Visualization; Browsing · CPC title