Suggesting alternate data mappings for charts

摘要

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.

主权项

1. A method for presenting data mapping alternatives for creating a visual representation of a set of data, comprising:
identifying 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; analyzing the set of data and properties associated with the set of data; based on the analysis, determining data mapping alternatives for the set of data; ranking the determined data mapping alternatives for the set of data by generating a score for each of the data mapping alternatives according to a scoring system comprising static scores and score multipliers, the static scores being mapped against each of a plurality of chart selection rules that determine how appropriate a set of categories and value series are for a predetermined chart type and data mapping, the score multipliers being mapped against a data orientation, series-axis mappings and filtering rules, the score for each of the data mapping alternatives being weighted with a multiplier according to a likelihood that one of a row-wise orientation and a column-wise orientation reflects the set of data; and presenting, in a user interface comprising a recommendations pane and a charts pane, the determined data mapping alternatives for selection, the data mapping alternatives being presented as a scrollable list of recommended charts in the recommendations pane for modification by a user within the user interface.