Visualizing high-cardinality data

• US 9,449,408 B2
• Filed: 03/12/2014
• Issued: 09/20/2016
• Est. Priority Date: 07/25/2013
• Status: Active Grant

• Current Assignee: SAS Institute Incorporated
• Original Assignee: SAS Institute Incorporated
• Inventors: Benson, Jordan Riley, Caira, David J., Dotson, Douglas R., Everdyke, Lisa Hope, Abousalh-Neto, Nascif A.
• Primary Examiner(s): WU, XIAO MIN
• Assistant Examiner(s): Lhymn, Sarah
• Application Number:
  US14/206,477
• Publication Number:
  US 20150029213A1
• Time in Patent Office: 923 Days
• Field of Search: 345/418, 345/440, 345/440.2, 345/441, 345/442, 345/443, 345/472, 345/501, 345/619, 345/620, 345/621, 345/625
• US Class Current: 1/1
• CPC Class Codes: G06T 11/206 Drawing of charts or graphs

Abstract

A method of visualizing high-cardinally data is provided. A graph is presented on a display. The graph includes a first axis, a second axis, and a plurality of value markers. The first axis includes a minimum value and a maximum value and the second axis includes a plurality of category values. A selection indicator identifying selection of a first value marker of the plurality of value markers is received. The first value marker indicates a value for a category value of the plurality of category values. A second plurality of category values is determined based on the category value. The graph and a second graph are presented on the display. The second graph includes a third axis, a fourth axis, and a second plurality of value markers. The third axis includes a second minimum value and a second maximum value.

Claims

1. A non-transitory computer-readable medium having stored thereon computer-readable instructions that when executed by a computing device cause the computing device to:

present a graph on a display,

wherein the graph includes a first axis, a second axis, and a first plurality of value markers,

wherein the first axis includes a minimum value and a maximum value and the second axis includes a plurality of category values,

wherein each value marker of the first plurality of value markers indicates an aggregate value representing a respective category value of the plurality of category values;

receive a selection indicator identifying selection of a first value marker of the first plurality of value markers,

wherein the first value marker indicates the aggregate value for a category value of the plurality of category values associated with the first value marker;

automatically identify a second plurality of category values in response to receipt of the selection indicator,

wherein the second plurality of category values are subcategories of the category value of the selected first value marker;

in response to automatically identifying the second plurality of category values, automatically compute a value for each respective subcategory value of the second plurality of category values from the aggregate value indicated by the first value marker; and

automatically present both the graph including each value marker of the first plurality of value markers and a second graph together on the display,

wherein the second graph includes a third axis, a fourth axis, and a second plurality of value markers distinct from the first plurality of value markers,

wherein each value marker of the second plurality of value markers indicates the computed value associated with a respective subcategory value of the second plurality of category values.

2. The computer-readable medium of claim 1, wherein the second plurality of value markers are not visible until the second graph is presented on the display.

3. The computer-readable medium of claim 1, wherein the category value is stored in association with the second plurality of category values.

4. The computer-readable medium of claim 1, wherein the second graph extends from the first value marker on the graph.

5. The computer-readable medium of claim 4, wherein the first axis is presented in a horizontal direction, and the second axis is presented in a vertical direction relative to the first axis, wherein the third axis is parallel to the first axis and the fourth axis is parallel to the second axis.

6. The computer-readable medium of claim 4, wherein the first axis is presented in a horizontal direction, and the second axis is presented in a vertical direction relative to the first axis, wherein the fourth axis is parallel to the first axis and the third axis is parallel to the second axis.

7. The computer-readable medium of claim 4, wherein the first axis is presented in a vertical direction, and the second axis is presented in a horizontal direction relative to the first axis, wherein the third axis is parallel to the first axis and the fourth axis is parallel to the second axis.

8. The computer-readable medium of claim 4, wherein the first axis is presented in a vertical direction, and the second axis is presented in a horizontal direction relative to the first axis, wherein the fourth axis is parallel to the first axis and the third axis is parallel to the second axis.

9. The computer-readable medium of claim 4, wherein the computer-readable instructions further cause the computing device to remove the presented graph from the display after receiving the selection indicator and to present the graph on the display reduced in size after removing the graph.

10. The computer-readable medium of claim 9, wherein a graph type of the graph is a histogram.

11. The computer-readable medium of claim 10, wherein a graph type of the second graph is selected from the group consisting of a histogram, a bar graph, a space filling chart, and a scatter plot.

12. The computer-readable medium of claim 4, wherein a graph type of the graph is selected from the group consisting of a histogram, a binned bar graph, and a bar graph.

13. The computer-readable medium of claim 4, wherein a graph type of the graph is a binned bar graph, wherein the binned bar graph comprises a bar graph that includes a mean indicator, a minimum indicator, and a maximum indicator for each category value of the plurality of category values, wherein the mean indicator indicates an average value for each category value of the plurality of category values, the minimum indicator indicates a minimum value for each category value of the plurality of category values, and the maximum indicator indicates a maximum value for each category value of the plurality of category values.

14. The computer-readable medium of claim 4, wherein a graph type of the second graph is selected from the group consisting of a histogram, a bar graph, a space filling chart, and a scatter plot.

15. The computer-readable medium of claim 4, wherein the computer-readable instructions further cause the computing device to remove the presented graph from the display after receiving the selection indicator and to present the graph on the display in a reversed orientation after removing the graph.

16. A system comprising:

a processor; and

a non-transitory computer-readable medium operably coupled to the processor, the computer-readable medium having computer-readable instructions stored thereon that, when executed by the processor, cause a computing device to

present a graph on a display,

wherein the graph includes a first axis, a second axis, and a first plurality of value markers,

wherein the first axis includes a minimum value and a maximum value and the second axis includes a plurality of category values,

wherein each value marker of the first plurality of value markers indicates an aggregate value representing a respective category value of the plurality of category values;

receive a selection indicator identifying selection of a first value marker of the first plurality of value markers,

wherein the first value marker indicates the aggregate value for a category value of the plurality of category values associated with the first value marker;

automatically identify a second plurality of category values in response to receipt of the selection indicator,

wherein the second plurality of category values are subcategories of the category value of the selected first value marker;

in response to automatically identifying the second plurality of category values, automatically compute a value for each respective subcategory value of the second plurality of category values from the aggregate value indicated by the first value marker; and

automatically present both the graph including each value marker of the first plurality of value markers and a second graph together on the display,

wherein the second graph includes a third axis, a fourth axis, and a second plurality of value markers distinct from the first plurality of value markers,

wherein each value marker of the second plurality of value markers indicates the computed value associated with a respective subcategory value of the second plurality of category values.

17. The system of claim 16, wherein the second plurality of value markers are not visible until the second graph is presented on the display.

18. The system of claim 16, wherein the second graph extends from the first value marker on the graph.

19. The system of claim 18, wherein the first axis is presented in a horizontal direction, and the second axis is presented in a vertical direction relative to the first axis, wherein the third axis is parallel to the first axis and the fourth axis is parallel to the second axis.

20. The system of claim 18, wherein the first axis is presented in a horizontal direction, and the second axis is presented in a vertical direction relative to the first axis, wherein the fourth axis is parallel to the first axis and the third axis is parallel to the second axis.

21. The system of claim 18, wherein the first axis is presented in a vertical direction, and the second axis is presented in a horizontal direction relative to the first axis, wherein the third axis is parallel to the first axis and the fourth axis is parallel to the second axis.

22. The system of claim 18, wherein the first axis is presented in a vertical direction, and the second axis is presented in a horizontal direction relative to the first axis, wherein the fourth axis is parallel to the first axis and the third axis is parallel to the second axis.

23. The system of claim 18, wherein the computer-readable instructions further cause the computing device to remove the presented graph from the display after receiving the selection indicator and to present the graph on the display reduced in size after removing the graph.

24. A method of visualizing high-cardinality data, the method comprising:

presenting a graph on a display,

wherein the graph includes a first axis, a second axis, and a first plurality of value markers,

wherein the first axis includes a minimum value and a maximum value and the second axis includes a plurality of category values,

wherein each value marker of the first plurality of value markers indicates an aggregate value representing a respective category value of the plurality of category values;

receiving a selection indicator identifying selection of a first value marker of the first plurality of value markers,

wherein the first value marker indicates the aggregate value for a category value of the plurality of category values associated with the first value marker;

automatically identifying, by a computing device, a second plurality of category values in response to receipt of the selection indicator,

wherein the second plurality of category values are subcategories of the category value of the selected first value marker;

in response to automatically identifying the second plurality of category values, automatically computing, by the computing device, a value for each respective subcategory value of the second plurality of category values from the aggregate value indicated by the first value marker; and

automatically presenting both the graph including each value marker of the first plurality of value markers and a second graph together on the display,

wherein the second graph includes a third axis, a fourth axis, and a second plurality of value markers distinct from the first plurality of value markers,

wherein each value marker of the second plurality of value markers indicates the computed value associated with a respective subcategory value of the second plurality of category values.

25. The method of claim 24, wherein the second plurality of value markers are not visible until the second graph is presented on the display.

26. The method of claim 24, wherein the second graph extends from the first value marker on the graph.

27. The method of claim 26, wherein the first axis is presented in a horizontal direction, and the second axis is presented in a vertical direction relative to the first axis, wherein the third axis is parallel to the first axis and the fourth axis is parallel to the second axis.

28. The method of claim 26, wherein the first axis is presented in a horizontal direction, and the second axis is presented in a vertical direction relative to the first axis, wherein the fourth axis is parallel to the first axis and the third axis is parallel to the second axis.

29. The method of claim 26, wherein the first axis is presented in a vertical direction, and the second axis is presented in a horizontal direction relative to the first axis, wherein the third axis is parallel to the first axis and the fourth axis is parallel to the second axis.

30. The method of claim 26, wherein the first axis is presented in a vertical direction, and the second axis is presented in a horizontal direction relative to the first axis, wherein the fourth axis is parallel to the first axis and the third axis is parallel to the second axis.

31. The method of claim 26, wherein the presented graph is removed from the display after receiving the selection indicator and presented on the display reduced in size after being removed.

32. The method of claim 26, wherein the presented graph is removed from the display after receiving the selection indicator and presented on the display reversed in orientation after being removed.