Filtering popup secondary data visualizations according to selected data from primary data visualizations

Patent metadata

Field	Value
Publication number	US-10656779-B1
Application number	US-201816127108-A
Country	US
Kind code	B1
Filing date	Sep 10, 2018
Priority date	Sep 10, 2018
Publication date	May 19, 2020
Grant date	May 19, 2020

Abstract

A computing device displays a graphical user interface on a display. The graphical user interface has a data visualization region that displays a primary data visualization, which includes a plurality of visual marks. The primary data visualization represents a first set of data fields of a plurality of data fields from a dataset. The device receives user input in the graphical user interface to select one of the visual marks. In response to the user input, the device generates a secondary data visualization, filtered according to one or more data values. The data values correspond to the first set of data fields and are associated with the selected visual mark. The secondary data visualization represents a second set of data fields from the dataset. The device then displays the generated secondary data visualization in a tooltip for the selected data mark, overlaying a portion of the primary data visualization.

First claim

What is claimed is:

1. A method comprising:
at a computer having a display, one or more processors, and memory storing one or more programs configured for execution by the one or more processors:
creating a first worksheet, having a primary data visualization, in a data visualization workbook;
creating a second worksheet in the data visualization workbook, distinct from the first worksheet, having a secondary data visualization;
displaying the data visualization workbook in a graphical user interface on the display,
wherein:
the graphical user interface has a data visualization region that displays the primary data visualization, which comprises: a bar chart, a line graph, a map, a scatter plot, a pie chart, a heat map, an area chart, a circle plot, a treemap, or a bubble chart; and
the primary data visualization includes a plurality of visual marks representing a first set of data fields from a dataset, specified in the first worksheet;
receiving user input, in the graphical user interface, to invoke a tooltip definition window for the primary data visualization;
receiving user input in the tooltip definition window, to specify a reference to the secondary data visualization;
receiving user input in the graphical user interface to select a visual mark of the plurality of visual marks for the primary data visualization; and in response to the user input:
generating the secondary data visualization, for a second set of data fields from the dataset, specified in the second worksheet, wherein the secondary data visualization is filtered according to one or more data values, for the first set of data fields, associated with the selected visual mark; and
displaying the generated secondary data visualization in a tooltip overlaying a portion of the primary data visualization.

2. The method of claim 1 , wherein generating the secondary data visualization comprises:
generating a database query according to the one or more data values and according to the second set of data fields;
sending the database query to a database that includes the dataset, thereby retrieving a result set for the secondary data visualization; and
generating the secondary data visualization according to the result set.

3. The method of claim 1 , further comprising:
prior to receiving the user input, retrieving data for the second set of fields from the dataset and storing the retrieved data in a cache;
in response to the user input, retrieving data from the cache corresponding to the one or more data values.

4. The method of claim 1 , wherein the user input comprises hovering over the visual mark or selecting the visual mark.

5. The method of claim 1 , wherein the dataset includes one or more linked datasets.

6. The method of claim 1 , wherein displaying the generated data visualization in the tooltip further comprises:
automatically resizing the secondary data visualization such that the secondary data visualization is displayed within the tooltip.

7. The method of claim 1 , further comprising, in response to the user input:
generating a tertiary data visualization according to the one or more data values, wherein the tertiary data visualization represents a third set of data fields of the plurality of data fields from the dataset; and
concurrently displaying, in the tooltip, both the generated secondary data visualization and the generated tertiary data visualization.

8. The method of claim 1 , wherein the secondary data visualization has a view type selected from the group consisting of: bar chart, line graph, map, scatter plot, pie chart, heat map, area chart, circle plot, treemap, and bubble chart.

9. The method of claim 1 , wherein a first data value of the one or more data values corresponds to a first data field, in the first set of data fields, which is not in the second set of data fields, and generating the secondary data visualization further comprises:
computing one or more aggregate values for a second data field in the second set of data fields, aggregating only rows from the dataset whose corresponding data values for the first data field match the first data value.

10. A computing device, comprising:
one or more processors;
memory;
a display; and
one or more programs stored in the memory and configured for execution by the one or more processors, the one or more programs comprising instructions for:
creating a first worksheet, having a primary data visualization, in a data visualization workbook;
creating a second worksheet in the data visualization workbook, distinct from the first worksheet, having a secondary data visualization;
displaying the data visualization workbook in a graphical user interface on the display,
wherein:
the graphical user interface has a data visualization region that displays the primary data visualization, which comprises: a bar chart, a line graph, a map, a scatter plot, a pie chart, a heat map, an area chart, a circle plot, a treemap, or a bubble chart; and
the primary data visualization includes a plurality of visual marks representing a first set of data fields from a dataset, specified in the first worksheet;
receiving user input, in the graphical user interface, to invoke a tooltip definition window for the primary data visualization;
receiving user input in the tooltip definition window, to specify a reference to the secondary data visualization;
receiving user input in the graphical user interface to select a visual mark of the plurality of visual marks for the primary data visualization; and in response to the user input:
generating the secondary data visualization, for a second set of data fields from the dataset, specified in the second worksheet, wherein the secondary data visualization is filtered according to one or more data values, for the first set of data fields, associated with the selected visual mark; and
displaying the generated secondary data visualization in a tooltip overlaying a portion of the primary data visualization.

11. The computing device of claim 10 , wherein generating the secondary data visualization comprises:
generating a database query according to the one or more data values and according to the second set of data fields;
sending the database query to a database that includes the dataset, thereby retrieving a result set for the secondary data visualization; and
generating the secondary data visualization according to the result set.

12. The computing device of claim 10 , wherein the one or more programs further comprise instructions for:
prior to receiving the user input, retrieving data for the second set of fields from the dataset and storing the retrieved data in a cache;
in response to the user input, retrieving data from the cache corresponding to the one or more data values.

13. The computing device of claim 10 , wherein the user input comprises hovering over the visual mark or selecting the visual mark.

14. The computing device of claim 10 , wherein the dataset includes one or more linked datasets.

15. The computing device of claim 10 , wherein the one or more programs further comprise instructions that execute in response to the user input, for:
generating a tertiary data visualization according to the one or more data values, wherein the tertiary data visualization represents a third set of data fields of the plurality of data fields from the dataset; and
concurrently displaying, in the tooltip, both the generated secondary data visualization and the generated tertiary data visualization.

16. The computing device of claim 10 , wherein the secondary data visualization has a vie

Assignees

• Tableau Software Inc

Inventors

• Rueter Marc
• Kim Jun

Classifications

• G06F16/904 Primary

  Browsing; Visualisation therefor (for navigating the web G06F16/954; browsing optimisation for the web G06F16/957) · CPC title

• G06F3/04812 Primary

  Interaction techniques based on cursor appearance or behaviour, e.g. being affected by the presence of displayed objects · CPC title

• G06F16/9038

  Presentation of query results · CPC title

• G06T11/206

  Physics · mapped topic

• G06T11/26

  Drawing of charts or graphs · CPC title