Granted Patent B2

US 12,373,453 · App. 18/420,746 · Granted Jul 29, 2025

Inventors: Allison Anne Whilden (Redmond, WA); Dirk Karis (Seattle, WA); Vidya Raghavan Setlur (Portola Valley, CA); Rodion Degtyar (Sammamish, WA); Jonathan D. Que (Seattle, WA); Filippos Lymperopoulos (Seattle, WA)

Assignee: Tableau Software, LLC

G06F16/248G06F3/04817G06F3/0482G06F3/04847G06F3/0486G06F8/34G06F16/2428G06F16/244G06F16/26G06F16/287

Abstract

Claims (53)

1. A method, comprising:

at a computer system having one or more processors, a display, and memory storing one or more programs configured for execution by the one or more processors:

obtaining a plurality of interrelated block objects corresponding to a plurality of block cards displayed in a canvas region of a user interface, each block object having a corresponding specification that includes (i) a layout type; (ii) a mark type; (iii) one or more visual encodings; and (iv) one or more data fields of a data source, as specified in a respective block card of the plurality of block cards, wherein each block card is generated in response to user placement of one or more respective data field icons onto the canvas region and/or onto the block card, where the one or more respective data field icons represent data fields from the data source;

executing a plurality of queries, each query generated for each block object of the plurality of interrelated block objects to retrieve a respective set of tuples from the data source, each tuple comprising data values for the respective one or more data fields of the block object; and

generating a data visualization in accordance with the specifications corresponding to each block object of the plurality of interrelated block objects, wherein each tuple in each of the respective set of tuples is represented as a visual mark in the data visualization.

2. The method of claim 1 , wherein the plurality of interrelated block objects have parent-child relationships that form a directed acyclic graph.

3. The method of claim 2 , wherein:

respective relative positions of the plurality of block cards displayed in the canvas region form an adjacency graph; and

the directed acyclic graph is generated based on the adjacency graph.

4. The method of claim 2 , wherein a first block object has one or more ancestor block objects according to the parent-child relationships in the directed acyclic graph, and generating the data visualization includes:

determining a local level of detail for the first block object and local level of details for each of the one or more ancestor block objects, wherein a local level of detail for a respective block object is determined based on dimension data fields of the respective block object;

determining a complete level of detail for the first block object by performing a union of the local of detail for the first block object and the local level of detail for each of the one or more ancestor block objects; and

generating a first query, for the first block object, specifying aggregation of each measure data field of the first block object according to the complete level of detail for the first block object.

5. The method of claim 4 , wherein a respective layout type of the first block object is an inline arrangement, and the method includes:

executing the first query to retrieve a first set of tuples from the data source; and

displaying a respective visual mark for each of the retrieved set of tuples in a cell or visual component of the data visualization.

6. The method of claim 1 , wherein the data visualization includes a visual component for each block object.

7. A computer system, comprising:

a display generation component;

one or more input devices;

one or more processors; and

memory storing one or more programs, wherein the one or more programs are configured to be executed by the one or more processors, the one or more programs including instructions for:

obtaining a plurality of interrelated block objects corresponding to a plurality of block cards displayed in a canvas region of a user interface, each block object having a corresponding specification that includes (i) a layout type; (ii) a mark type; (iii) one or more visual encodings; and (iv) one or more data fields of a data source, as specified in a respective block card of the plurality of block cards, wherein each block card is generated in response to user placement of one or more respective data field icons onto the canvas region and/or onto the block card, where the one or more respective data field icons represent data fields from the data source;

executing a plurality of queries, each query generated for each block object of the plurality of interrelated block objects to retrieve a respective set of tuples from the data source, each tuple comprising data values for the respective one or more data fields of the block object; and

generating a data visualization in accordance with the specifications corresponding to each block object of the plurality of interrelated block objects, wherein each tuple in each of the respective set of tuples is represented as a visual mark in the data visualization.

8. The computer system of claim 7 , wherein the plurality of interrelated block objects have parent-child relationships that form a directed acyclic graph.

9. The computer system of claim 8 , wherein:

respective relative positions of the plurality of block cards displayed in the canvas region form an adjacency graph; and

the directed acyclic graph is generated based on the adjacency graph.

10. The computer system of claim 8 , wherein a first block object has one or more ancestor block objects according to the parent-child relationships in the directed acyclic graph, and generating the data visualization includes:

determining a local level of detail for the first block object and local level of details for each of the one or more ancestor block objects, wherein a local level of detail for a respective block object is determined based on dimension data fields of the respective block object;

determining a complete level of detail for the first block object by performing a union of the local of detail for the first block object and the local level of detail for each of the one or more ancestor block objects; and

generating a first query, for the first block object, specifying aggregation of each measure data field of the first block object according to the complete level of detail for the first block object.

11. The computer system of claim 10 , wherein a respective layout type of the first block object is an inline arrangement, and the one or more programs including instructions for:

executing the first query to retrieve a first set of tuples from the data source; and

displaying a respective visual mark for each of the retrieved set of tuples in a cell or visual component of the data visualization.

12. The computer system of claim 7 , wherein the data visualization includes a visual component for each block object.

13. A non-transitory computer readable storage medium storing one or more programs, the one or more programs comprising instructions, which, when executed by a computer system with a display generation component, and one or more input devices, cause the device to:

obtaining a plurality of interrelated block objects corresponding to a plurality of block cards displayed in a canvas region of a user interface, each block object having a corresponding specification that includes (i) a layout type; (ii) a mark type; (iii) one or more visual encodings; and (iv) one or more data fields of a data source, as specified in a respective block card of the plurality of block cards, wherein each block card is generated in response to user placement of one or more respective data field icons onto the canvas region and/or onto the block card, where the one or more respective data field icons represent data fields from the data source;

executing a plurality of queries, each query generated for each block object of the plurality of interrelated block objects to retrieve a respective set of tuples from the data source, each tuple comprising data values for the respective one or more data fields of the block object; and

generating a data visualization in accordance with the specifications corresponding to each block object of the plurality of interrelated block objects, wherein each tuple in each of the respective set of tuples is represented as a visual mark in the data visualization.

14. The non-transitory computer readable storage medium of claim 13 , wherein the plurality of interrelated block objects have parent-child relationships that form a directed acyclic graph.

15. The non-transitory computer readable storage medium of claim 14 , wherein:

respective relative positions of the plurality of block cards displayed in the canvas region form an adjacency graph; and

the directed acyclic graph is generated based on the adjacency graph.

16. The non-transitory computer readable storage medium of claim 14 , wherein a first block object has one or more ancestor block objects according to the parent-child relationships in the directed acyclic graph, and generating the data visualization includes:

determining a local level of detail for the first block object and local level of details for each of the one or more ancestor block objects, wherein a local level of detail for a respective block object is determined based on dimension data fields of the respective block object;

determining a complete level of detail for the first block object by performing a union of the local of detail for the first block object and the local level of detail for each of the one or more ancestor block objects; and

generating a first query, for the first block object, specifying aggregation of each measure data field of the first block object according to the complete level of detail for the first block object.

17. The non-transitory computer readable storage medium of claim 16 , wherein a respective layout type of the first block object is an inline arrangement, and the one or more programs including instructions for:

executing the first query to retrieve a first set of tuples from the data source; and

displaying a respective visual mark for each of the retrieved set of tuples in a cell or visual component of the data visualization.

18. The non-transitory computer readable storage medium of claim 13 , wherein the data visualization includes a visual component for each block object.

Continuity (5)

References Cited (81)