Visualization of cross-pivoted data

Patent metadata

Field	Value
Publication number	US-10186058-B2
Application number	US-201514938135-A
Country	US
Kind code	B2
Filing date	Nov 11, 2015
Priority date	Nov 11, 2015
Publication date	Jan 22, 2019
Grant date	Jan 22, 2019

Abstract

Various techniques for visualizing cross-pivoted tables are disclosed herein. In one embodiment, a method includes determining if a first dimension and a second dimension of a cross-pivoted table contain non-numerical values, the cross-pivoted table having a plurality of data points each dependent upon a first value in the first dimension and a second value in the second dimension. In response to determining that the first dimension and the second dimension contain non-numerical first and second values, the non-numerical first and second values can be converted to corresponding numerical first and second values. The method can then include plotting, on a display, a visual representation of the plurality of data points of the cross-pivoted table using the numerical first and second numerical values as first and second axis, respectively.

First claim

We claim:

1. A method for rendering a cross-pivoted table on a computing system having a processor and a display operatively coupled to the processor, the method comprising:
receiving a cross-pivoted table having a first dimension, a second dimension, and a plurality of data points each corresponding to a first value in the first dimension and a second value in the second dimension;
determining if the first values of the first dimension and the second values of the second dimension are non-numerical;
in response to determining that at least one of the first values of the first dimension or the second values of the second dimension are non-numerical, converting the at least one of the non-numerical first values of the first dimension or the second values of the second dimension to numerical values based on conversion rules that specify how different types of non-numerical values are to be converted to numerical values; and
plotting the plurality of data points on the display without flattening the cross-pivoted table to produce a visual representation of the plurality of data points of the cross-pivoted table based on the converted numerical values of the at least one of the first values of the first dimension or the second values of the second dimension.

2. The method of claim 1 wherein converting the at least one of the non-numerical first values of the first dimension or the second values of the second dimension to numerical values includes converting the at least one of the non-numerical first values of the first dimension or the second values of the second dimension to numerical values based on a data property of the first values of the first dimension or the second value of the second dimension.

3. The method of claim 1 wherein converting the at least one of the non-numerical first values of the first dimension or the second values of the second dimension to numerical values includes converting the at least one of the non-numerical first values of the first dimension or the second values of the second dimension to numerical values based on ASCII values, date values, or time values of the first values of the first dimension or the second values of the second dimension.

4. The method of claim 1 wherein converting the at least one of the non-numerical first values of the first dimension or the second values of the second dimension to numerical values includes assigning distinct numerical values to the at least one of the non-numerical first values of the first dimension or the second values of the second dimension to numerical values.

5. The method of claim 1 wherein converting the at least one of the non-numerical first values of the first dimension or the second values of the second dimension to numerical values includes assigning distinct and sequential numerical values to the at least one of the non-numerical first values of the first dimension or the second values of the second dimension to numerical values.

6. The method of claim 1 wherein producing the visual representation includes plotting the plurality of data points as a three-dimensional graph with the converted at least one of the numerical values of the first values of the first dimension or the second values of the second dimension as the first and second axes, respectively.

7. The method of claim 1 wherein:
the first values of the first dimension summarize data from a plurality of sub-categories; the method further includes:
receiving user selection to explore the plurality of sub-categories of the first dimension in relation to the outputted visual representation; and
outputting a three-dimensional graph of the sub-categories based on the user selection.

8. The method of claim 1 , further comprising:
receiving user selection to aggregate the first values or the second values in relation to the outputted visual representation; and
adjusting the outputted visual representation based on the user selection to aggregate the first values or the second values.

9. A computing system, comprising:
a processor, a memory, and a display operatively coupled to one another, wherein the memory contains instructions that when executed by the processor cause the processor to:
receive a cross-pivoted table having a first dimension, a second dimension, and a plurality of data points each corresponding to a first value in the first dimension and a second value in the second dimension, wherein at least one first value or at least one second value comprises a non-numerical value;
convert each non-numerical value to corresponding numerical values based on conversion rules that specify how different types of non-numerical values are to be converted to numerical values; and
plot individual data points on the display without flattening the cross-pivoted table to provide a visual representation of the plurality of data points of the cross-pivoted table based on the converted numerical values of the at least one of the first values of the first dimension or the second values of the second dimension.

10. The computer system of claim 9 , wherein the memory further stores instructions to cause the processor to:
determine if the at least one of the first values of the first dimension or the second values of the second dimension are text strings; and
based on a determination that the at least one of the first values or the second values are text strings, converting the at least one of the first values of the first dimension or the second values of the second dimension to corresponding numerical values based on a string value of the individual text strings of the at least one of the first values or the second values.

11. The computer system of claim 9 , wherein the memory further stores instructions to cause the processor to:
determine if the at least one of the first values of the first dimension or the second values of the second dimension are dates; and
based on a determination that the at least one of the first values or the second values are dates, converting the at least one of the first values of the first dimension or the second values of the second dimension to corresponding numerical values based on a date value of the individual dates of the at least one of the first values or the second values.

12. The computer system of claim 9 , wherein the memory further stores instructions to cause the processor to, based on a determination that the at least one of the first values or the second values are non-numerical, assign sequential numerical values to the at least one of the first values of the first dimension or the second values of the second dimension.

13. The computer system of claim 9 wherein the plurality of data points are plotted in a three-dimensional graph along a first axis and a second axis corresponding to the converted numerical values of the first values and second values, respectively.

14. A computer readable storage medium containing instructions that when executed by a processor cause the processor to perform a process, comprising:
determining if a first dimension and a second dimension of a cross-pivoted table contain non-numerical values, the cross-pivoted table having a plurality of data points each dependent upon a first value in the first dimension and a second value in the second dimension;
in response to determining that the first dimension and the second dimension contain non-numerical first and second values, respectively, converting the non-numerical first and second values to corresponding numerical first and second values based on conversion rules that specify how different types of non-numerical values are to be converted to numerical values; and

Assignees

• Microsoft Technology Licensing Llc

Inventors

• Peev Igor
• Sobhy Ehab
• Geselowitz Lewey
• Jayanty Paavany

Classifications

• G06T11/26 Primary

  Drawing of charts or graphs · CPC title

• G06F16/904

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

• G06F40/177

  of tables; using ruled lines · CPC title

• G06T19/00

  Manipulating three-dimensional [3D] models or images for computer graphics · CPC title

• G06F17/245

  Physics · mapped topic