Granted Patent B2

US 11,550,803 · App. 16/283,700 · Granted Jan 10, 2023

Inventors: Chris Stolte (Seattle, WA); Diane L. Tang (Palo Alto, CA); Patrick Hanrahan (Portola Valley, CA)

Assignee: The Board of Trustees of the Leland Stanford Jr. University

G06F16/248G06F3/0482G06F3/04842G06F3/04847G06F16/212G06F16/221G06F16/2282G06F16/252G06F16/282G06F16/283G06F40/177G06F40/18G06F16/26G06F2216/03Y10S707/954Y10S707/956Y10S707/959Y10S707/99942Y10S707/99943Y10S707/99944Y10S707/99945

Abstract

Claims (59)

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:

displaying, in a graphical user interface, a plurality of selectable fields from a multidimensional database that includes at least one data hierarchy, wherein (i) one or more first fields of the plurality of selectable fields are categorical fields, and (ii) one or more second fields of the plurality of selectable fields are quantitative fields; and

receiving a first user selection of a respective first field from the one or more first fields;

receiving a second user selection, distinct from the first user selection, of a respective second field from the one or more second fields;

after receiving the first and second user selections:

generating, in accordance with the received user selections, a plurality of data marks to be displayed in a data visualization, each data mark corresponding to a respective retrieved tuple of data from the multidimensional database and each retrieved tuple including the respective first field and the respective second field, wherein: (i) each data mark has an x-position defined according to data for the respective first field in the respective tuple, and (ii) each data mark has a y-position defined according to data for the respective second field in the respective tuple; and

displaying, in the graphical user interface, the data visualization, wherein the data visualization includes the plurality of data marks.

2. The method of claim 1 , further comprising:

displaying a first label for the respective first field in a first region of the graphical user interface, after receiving the first user selection; and

displaying a second label, different from the first label, for the respective second field in the first region of the graphical user interface, after receiving the second user selection.

3. The method of claim 2 , wherein the data visualization is displayed in a second region, different from the first region, of the graphical user interface.

4. The method of claim 3 , wherein the first and second regions are adjacent to each other in the graphical user interface.

5. The method of claim 1 , wherein:

the respective first field is a first level of the at least one data hierarchy; and

the method further comprises:

receiving a user action to drill into a second level of the at least one data hierarchy, the second level being associated with a respective third field of the one or more first fields; and

in response to receiving the user action, updating display of the data visualization in accordance with the received user action.

6. The method of claim 5 , wherein the user action to drill is (i) a drill down operation or (ii) a drill up operation.

7. The method of claim 1 , further comprising, before generating the plurality of data marks to be displayed in the data visualization:

receiving a third user selection, distinct from the first and second user selections, of a respective third field from the one or more first fields;

wherein each data mark is further defined according to data for the respective third field in the respective tuple.

8. The method of claim 7 , wherein each data mark has a z-position defined according to data for the respective third field in the respective tuple.

9. The method of claim 7 , wherein each data mark has a shape, size, or color defined according to data for the respective third field in the respective tuple.

10. The method of claim 7 , wherein each data mark is broken down and colored according to the data for the respective third field in the respective tuple.

11. The method of claim 7 , wherein each data mark has a label, displayed as part of the data visualization, defined according to data for the respective third field in the respective tuple.

12. The method of claim 1 , wherein receiving the first and second user selections comprises detecting two distinct drag-and-drop operations.

13. A computer system for generating data visualizations, comprising:

a display;

one or more processors;

memory; 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:

displaying, in a graphical user interface, a plurality of selectable fields from a multidimensional database that includes at least one data hierarchy, wherein (i) one or more first fields of the plurality of selectable fields are categorical fields, and (ii) one or more second fields of the plurality of selectable fields are quantitative fields; and

receiving a first user selection of a respective first field from the one or more first fields;

receiving a second user selection, distinct from the first user selection, of a respective second field from the one or more second fields;

after receiving the first and second user selections:

generating, in accordance with the received user selections, a plurality of data marks to be displayed in a data visualization, each data mark corresponding to a respective retrieved tuple of data from the multidimensional database and each retrieved tuple including the respective first field and the respective second field, wherein: (i) each data mark has an x-position defined according to data for the respective first field in the respective tuple, and (ii) each data mark has a y-position defined according to data for the respective second field in the respective tuple; and

displaying, in the graphical user interface, the data visualization, wherein the data visualization includes the plurality of data marks.

14. The computer system of claim 13 , wherein the one or more programs further comprise instructions for:

displaying a first label for the respective first field in a first region of the graphical user interface, after receiving the first user selection; and

displaying a second label, different from the first label, for the respective second field in the first region of the graphical user interface, after receiving the second user selection.

15. The computer system of claim 14 , wherein the data visualization is displayed in a second region, different from the first region, of the graphical user interface.

16. The computer system of claim 15 , wherein the first and second regions are adjacent to each other in the graphical user interface.

17. The computer system of claim 13 , wherein:

the respective first field is a first level of the at least one data hierarchy; and

the one or more programs further comprise instructions for:

receiving a user action to drill into a second level of the at least one data hierarchy, the second level being associated with a respective third field of the one or more first fields; and

in response to receiving the user action, updating display of the data visualization in the second region in accordance with the received user action.

18. The computer system of claim 17 , wherein the user action to drill is (i) a drill down operation or (ii) a drill up operation.

19. The computer system of claim 13 , wherein the one or more programs further comprise instructions for, before generating the plurality of data marks to be displayed in the data visualization:

receiving a third user selection, distinct from the first and second user selections, of a respective third field from the one or more first fields;

wherein each data mark is further defined according to data for the respective third field in the respective tuple.

20. A non-transitory computer-readable storage medium storing one or more programs configured for execution by a computer system having a display, one or more processors, and memory, the one or more programs comprising instructions for:

displaying, in a graphical user interface, a plurality of selectable fields from a multidimensional database that includes at least one data hierarchy, wherein (i) one or more first fields of the plurality of selectable fields are categorical fields, and (ii) one or more second fields of the plurality of selectable fields are quantitative fields; and

receiving a first user selection of a respective first field from the one or more first fields;

receiving a second user selection, distinct from the first user selection, of a respective second field from the one or more second fields;

after receiving the first and second user selections:

generating, in accordance with the received user selections, a plurality of data marks to be displayed in a data visualization, each data mark corresponding to a respective retrieved tuple of data from the multidimensional database and each retrieved tuple including the respective first field and the respective second field, wherein: (i) each data mark has an x-position defined according to data for the respective first field in the respective tuple, and (ii) each data mark has a y-position defined according to data for the respective second field in the respective tuple; and

displaying, in the graphical user interface, the data visualization, wherein the data visualization includes the plurality of data marks.

Assignments (1)

Continuity (12)