Patent ID: 8560522

Claim:
A method for providing additional time periods in a query interface comprising: identifying a query; triggering a partial execution of the identified query to identify fields in a query result having a date field type; classifying, using a processing device, the identified fields having a date field type as date fields; appending, using the processing device, the identified query to compute a year, quarter, month, and week of a date in each classified date field and create new respective time period fields in the query result storing the computed year, month, quarter, and week for each classified date field; triggering an execution of the appended query; generating, from the appended query execution, the query result including the computed year, quarter, month, and week field data and fields for with each classified date field; adding each of the classified date fields and the computed year, quarter, month, and week fields to a filter menu in the query interface; designating each of the computed year, quarter, month, and week fields as selectable in a first dimension menu of the query interface; adding a selectable count function for each of the computed year, quarter, month, and week fields to a second dimension menu of the query interface, wherein the count function counts a number of instances of a unique field value; 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 the query interface; displaying in a first dimension of the interface data from the at least one selected field from the first dimension menu; 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; identifying a range of values associated with each of the fields added to the filter menu; providing an option in the filter menu to select at least one value in the range of values associated with at least one field added to the filter menu; and filtering the query result based on a selection of the at least one value in the range of values associated with at least one field added to the filter menu.