Ranking graphical visualizations of a data set according to data attributes

摘要

A computer-implemented system, method and computer readable medium to generate graphical visualizations corresponding to a data set populated in a web-based document, such as a spreadsheet. The spreadsheet is accessible in an interne or cloud-based system, and enables users to automatically create graphical visualizations or representations based on recommendations by a spreadsheet application. The graphical visualizations may be automatically ranked such that the system provides the recommendations to the user for display. Automatic ranking is accomplished, for example, by determining data types from identifying column type, differentiating column types, and extracting data sets having attributes corresponding to various graphical visualizations.

主权项

1. A computer-implemented method to generate a graphical visualization in a web-based document application, comprising:
identifying a data type for each column in a data table having a first set of data; differentiating the data types between each of the columns in the data table; determining a second data set derived from the first data set and corresponding to at least one graphical visualization with an expected data set in a plurality of graphical visualizations, and when the data type for a respective column is not relevant to the expected data set of the at least one graphical visualization, removing the respective column in the data table; selecting a set of graphical visualizations comprised of each graphical visualization having the expected data set suitable for the second data set; ranking, based on a criteria and the second data set, each graphical visualization in the set of graphical visualizations to graphically represent the second data set; generating at least one graphical visualization from the set of graphical visualizations for display based on the ranking; and determining each of the second data sets by:
rearranging at least one of the columns to correspond with a respective graphical visualization in the set of graphical visualizations, andpartitioning the columns in the data table to form separate partitioned second data sets, each set having columns with similar data types; and examining the partitioned second data sets to determine respective data structures.