Suggesting alternate data mappings for charts
First Claim
Patent Images
1. A method for presenting data mapping alternatives for creating a visual representation of a set of data, comprising:
- receiving the set of data for analysis;
modifying the set of data to form a modified set of data;
receiving a selection of a chart type;
analyzing the modified set of data and properties associated with the modified set of data for the chart type in response to the selection of the chart type;
based on the analysis, determining data mapping alternatives for the modified set of data for the chart type, wherein determining the data mapping alternatives for the modified set of data for the chart type comprises;
determining different data orientations for the modified set of data for the chart type,determining different series mappings for the different data orientations for the chart type, anddetermining different axis mappings for the different series mappings to form a different series-axis mapping for each data mapping alternative;
ranking the data mapping alternatives based on the different data orientations, the different series-axis mappings and filtering rules; and
presenting, in a user interface, the data mapping alternatives for the chart type as applied to the modified set of data for selection based at least on the ranking.
2 Assignments
0 Petitions
Accused Products
Abstract
Data mapping alternatives for creating a visual representation of a set of data are presented. A set of data is identified for analysis. The identified set of data and properties associated with the identified set of data are analyzed. Based on the analysis, data mapping alternatives for the identified set of data are determined. The determined data mapping alternatives for the identified set of data are ranked. The determined data mapping alternatives are presented in an order according to the ranking of the determined data mapping alternatives.
-
Citations
20 Claims
-
1. A method for presenting data mapping alternatives for creating a visual representation of a set of data, comprising:
-
receiving the set of data for analysis; modifying the set of data to form a modified set of data; receiving a selection of a chart type; analyzing the modified set of data and properties associated with the modified set of data for the chart type in response to the selection of the chart type; based on the analysis, determining data mapping alternatives for the modified set of data for the chart type, wherein determining the data mapping alternatives for the modified set of data for the chart type comprises; determining different data orientations for the modified set of data for the chart type, determining different series mappings for the different data orientations for the chart type, and determining different axis mappings for the different series mappings to form a different series-axis mapping for each data mapping alternative; ranking the data mapping alternatives based on the different data orientations, the different series-axis mappings and filtering rules; and presenting, in a user interface, the data mapping alternatives for the chart type as applied to the modified set of data for selection based at least on the ranking. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11)
-
-
12. A chart recommendation system, comprising:
-
at least one processor; and memory encoding computer executable instructions that, when executed by the at least one processor, perform a method comprising; receiving a set of data for analysis, the set of data comprising at least one row and at least one column in a chart; modifying the set of data by trimming empty rows and empty columns to form a modified set of data; receiving a selection of a chart type; determining at least two data mapping alternatives for the modified set of data for the chart type in response to the selection of the chart type; ranking the at least two data mapping alternatives based on data orientation, series-axis mappings and filtering rules for the chart type; and presenting the data mapping alternatives for the chart type as applied to the modified set of data based at least on the ranking. - View Dependent Claims (13, 14, 15, 16, 17, 18, 19)
-
-
20. A computing device, comprising:
-
memory for storing data; and a processor, coupled to the memory, the processor configured to; receive a set of data for analysis, the set of data comprising at least one row and at least one column in a chart; receive a selection of a chart type; modify the set of data by trimming empty rows and empty columns and addressing discontinuous ranges to form a modified set of data; analyze the modified set of data and properties associated with the modified set of data for the chart type; based on the analysis, determine data mapping alternatives for the modified set of data by; determining data orientations for the modified set of data for the chart type, determining series mappings for the modified set of data for the chart type, and determining axis mappings for the modified set of data for the chart type; rank the data mapping alternatives based on the data orientations, the series mappings and filtering rules for the chart type; and present, in a user interface, the data mapping alternatives as applied to the modified set of data for selection based at least on the ranking.
-
Specification