Patent ID: 8423567

Claim:
A method for generating an interface for modifying a query output comprising: identifying a query; triggering a partial execution of the identified query to identify a field type of each field in a query result; classifying, using a processing device, each field in the query result as one of text, numerical, and date according to its respective field type; for those fields classified as text: adding each respective field to a filter menu in the interface; designating each respective field as selectable in a first dimension menu of the interface; and adding a selectable count function for each respective field to a second dimension menu of the interface, wherein the count function counts a number of instances of a unique field value; for those fields classified as numerical, adding a selectable mathematical function operative on data in each respective field to the second dimension menu of the interface; for those fields classified as date, adding each respective field to the filter menu; receiving a selection of at least one field in the first dimension menu and at least one function in the second dimension menu; appending, using the processing device, the identified query to apply the at least one selected function added in the second dimension menu according to the at least one selected field in the first dimension menu; displaying in a first dimension of the interface data from the at least one selected field from the first dimension menu; and displaying in a second dimension of the interface a result of applying the selected function in the appended query to data displayed in the first dimension.