VISUAL TIME FILTER CONTROL TOOL FOR DATA ANALYSIS APPLICATIONS

• US 20130007645A1
• Filed: 06/30/2011
• Published: 01/03/2013
• Est. Priority Date: 06/30/2011
• Status: Abandoned Application

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Kurniawan, Ricky, Karunakaran, Rajeev, Philip, Sujit Mathew
• Application Number:
  US13/172,828
• Publication Number:
  US 20130007645A1
• Time in Patent Office: Days
• US Class Current: 715/769
• CPC Class Codes: G06F 3/04847 Interaction techniques to control parameter settings, e.g. interaction with sliders or dials

Abstract

A visual time filter control (“VTFC”) tool enables a user to select one or more time periods for which the user desires to time filter data via a graphical user interface (“GUI”). According to one aspect, a computer-implemented method for filtering data by time includes displaying a GUI of a VTFC tool. The GUI includes a plurality of selectable time periods. The method further includes associating the VTFC tool with data, receiving a selection of one or more of the plurality of selectable time periods via the GUI of the VTFC tool, filtering the data in accordance with the selection to create a filtered dataset of the data, and displaying the filtered dataset.

Claims

1. A computer storage medium having computer readable instructions stored thereupon that, when executed by a computer, cause the computer to:

display a graphical user interface of a visual time filter control tool, the graphical user interface comprising a plurality of selectable time periods;

associate the visual time filter control tool with data;

receive a selection of one or more of the plurality of selectable time periods via the graphical user interface of the visual time filter control tool;

filter the data in accordance with the selection of the one or more of the plurality of selectable time periods to create a filtered dataset of the data; and

display the filtered dataset.

2. The computer storage medium of claim 1, wherein the selection of the one or more of the plurality of selectable time periods comprises the selection of the one or more of the plurality of selectable time periods via a click operation performed via an input device that is in communication with the computer.

3. The computer storage medium of claim 2, wherein the click operation performed via the input device is a single-click operation.

4. The computer storage medium of claim 2, wherein the click operation performed via the input device is a click-and-drag operation.

5. The computer storage medium of claim 2, wherein the click operation performed via the input device is a shift plus click operation.

6. The computer storage medium of claim 1, wherein the visual time filter control tool further comprises a time view in which the plurality of selectable time periods are shown, the time view comprising:

a plurality of time labels, each of which is associated with one or more of the plurality of selectable time periods, and each of which comprises one of a year, a quarter, a month, or a day; and

a parent label providing context for the plurality of time labels, the parent label comprising one of a year or a month.

7. The computer storage medium of claim 6, wherein the visual time filter control tool further comprises a time level selector via which a time level for the plurality of time labels is selected, the time level comprising one of years, quarters, months, or days.

8. The computer storage medium of claim 1, wherein the visual time filter control tool further comprises a filter label identifying the one or more of the plurality of selectable time periods selected to create the filtered dataset of the data.

9. A computer-implemented method for filtering data by time, the computer-implemented method comprising performing computer-implemented operations for:

displaying a graphical user interface of a visual time filter control tool comprising a plurality of selectable time periods;

associating the visual time filter control tool with data;

receiving a selection of one or more of the plurality of selectable time periods via the graphical user interface of the visual time filter control tool;

filtering the data in accordance with the selection of the one or more of the plurality of selectable time periods to create a filtered dataset of the data; and

displaying the filtered dataset.

10. The computer-implemented method of claim 9, wherein receiving the selection of the one or more of the plurality of selectable time periods comprises receiving the selection of the one or more of the plurality of selectable time periods via a click operation performed via an input device.

11. The computer-implemented method of claim 10, wherein the click operation performed via the input device is a single-click operation.

12. The computer-implemented method of claim 10, wherein the click operation performed via the input device is a click-and-drag operation, the click-and-drag operation being facilitated by at least one grip element.

13. The computer-implemented method of claim 12, wherein when the grip element is dragged beyond an edge of the plurality of selectable time periods, at least one additional selectable time period becomes viewable.

14. The computer-implemented method of claim 10, wherein the click operation performed via the input device is a shift plus click operation.

15. The computer-implemented method of claim 9, wherein the visual time filter control tool further comprises a time view in which the plurality of selectable time periods are shown, the time view comprising:

a plurality of time labels, each of which is associated with one or more of the plurality of selectable time periods, and each of which comprises one of a year, a quarter, a month, or a day; and

a parent label providing context for the plurality of time labels, the parent label comprising one of a year or a month.

16. The computer-implemented method of claim 15, wherein the graphical user interface further comprises a scroll lens configured to be selected and dragged to reveal additional selectable time periods that were not previously viewable in the time view.

17. The computer-implemented method of claim 15, wherein the visual time filter control tool further comprises a time level selector via which a time level for the plurality of time labels is selected, the time level comprising one of years, quarters, months, or days.

18. The computer-implemented method of claim 9, wherein the visual time filter control tool further comprises a filter label identifying the one or more of the plurality of selectable time periods selected to create the filtered dataset of the data.

19. The computer-implemented method of claim 9, further comprising simultaneously displaying the data and the visual time filter control tool within a spreadsheet.

20. A computer-implemented method for filtering data by time, the computer-implemented method comprising performing computer-implemented operations for:

displaying a graphical user interface of a visual time filter control tool, the graphical user interface comprising

a time view comprising a plurality of selectable time periods, each of which is associated with one of a plurality of time labels, and each of which comprises one of a year, a quarter, a month, or a day,

a filter label identifying one or more of the plurality of time periods for which a time filter has been applied via the visual time filter control tool, and

a parent label comprising context for the plurality of time labels, the context comprising a particular year if the plurality of time labels is months and a particular month if the plurality of time labels is days; and

displaying a filtered dataset comprising data filtered via the time filter, the filtered dataset being displayed in a chart.