摘要 |
Methods, program products, and systems for analytical charting are described. A system implementing analytical charting techniques can receive a selection input from a data view displaying data retrieved from a database table. The system can determine a context of the selection input, a data environment in which the selection input is received, and characteristics of data being selected. Based on the context, the data environment, and the characteristics, the system can generate a chart data grouping that specifies a relationship between data in a chart. The system can automatically specify one or more data series for the chart based on the chart data grouping. The system can generate chart parameters automatically and transparently to the user. The system can provide the system-generated chart parameters for display and allow user modification to the system-generated chart parameters. The system can then generate a chart using the chart parameters. |
主权项 |
1. A method for generating a chart, the method comprising:
providing for display a data view of data, the data view comprising a plurality of data cells each displaying a data item, the plurality of data cells being organized into columns; receiving, by one or more processors, an input selecting a first data cell of the plurality of data cells, the first data cell being located in a first column, the first column being any column in the data view, the first data cell being any data cell in the first column; in response to the input, comparing the input with one or more specified criteria for determining whether the input is for generating the chart; based on determining that the input is for generating the chart, determining, by the one or more processors, a data type of the first data cell; upon determining that the data type is a non-numerical data type, determining, by the one or more processors, that a most likely chart type of the chart is a count of data items in the first column grouped by distinct data items in the first column; designating, by the one or more processors, the most likely chart type as one or more chart parameters for the chart, including designating a first axis of the chart for the distinct data items and designating a second axis of the chart for respective counts of data items grouped by the distinct data items; and generating the chart representing the respective counts. |