Row drill down of an event statistics time chart

• US 10,444,956 B2
• Filed: 01/31/2018
• Issued: 10/15/2019
• Est. Priority Date: 10/05/2014
• Status: Active Grant

• Current Assignee: Splunk Inc.
• Original Assignee: Splunk Inc.
• Inventors: Burke, Cory Eugene, Feeney, Katherine Kyle, Lamas, Divanny I., Robichaud, Marc Vincent, Ness, Matthew G., Lee, Clara E.
• Primary Examiner(s): Baderman, Scott T
• Assistant Examiner(s): Mrabi, Hassan
• Application Number:
  US15/885,486
• Publication Number:
  US 20180157400A1
• Time in Patent Office: 622 Days
• Field of Search: 715227
• CPC Class Codes: G06F 16/221 Column-oriented storage; Management thereof
• CPC Class Codes: G06F 16/242 Query formulation
• CPC Class Codes: G06F 16/2425 Iterative querying; Query formulation based on the results of a preceding query
• CPC Class Codes: G06F 16/2455 Query execution
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: G06F 16/951 Indexing; Web crawling techniques
• CPC Class Codes: G06F 3/0482 Interaction with lists of selectable items, e.g. menus
• CPC Class Codes: G06F 3/04842 Selection of displayed objects or displayed text elements G06F3/0482 takes precedence
• CPC Class Codes: G06F 3/04847 Interaction techniques to control parameter settings, e.g. interaction with sliders or dials
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174
• CPC Class Codes: G06F 9/451 Execution arrangements for user interfaces
• CPC Class Codes: G06V 10/22 by selection of a specific region containing or referencing a pattern; Locating or processing of specific regions to guide the detection or recognition

Abstract

In embodiments of statistics time chart interface row mode drill down, a first interface is displayed in a table format that includes columns each having a column heading comprising a different value, each different value associated with a particular event field, and includes rows each with a time increment and one or more aggregated metrics, each aggregated metric representing a number of events having a field-value pair that matches the different value represented in one of the columns and within the time increment over which the aggregated metric is calculated. A row that includes the time increment and the aggregated metrics can be emphasized in the first interface, and in response, a menu is displayed with selectable options to transition to a second interface based on a selected one of the options.

Claims

1. A computer-implemented method for displaying statistics for a set of events, wherein each event in the set of events includes a plurality of field-value pairs, the method comprising:

causing display of a first interface that includes; and

a first column that includes a first column heading indicating a first value of a first field-value pair of the plurality of field-value pairs;

a first row indicating a first time increment; and

a first aggregated metric that corresponds to each of the first column and the first row and indicates a first number of events included in a first subset of the set of events, wherein each event included in the first subset of the set of events occurred within the first time increment and the first field-value pair for each event included in the first subset of the set of events includes the first value;

causing display of a second interface, in response to a user selection of the first row, wherein the second interface is associated with the first row.

2. The computer-implemented method of claim 1, further comprising:

receiving a search query; and

generating the set of the events based on the received search query, wherein each event included in the set of events reflects activity in an information technology environment of at least one computing system.

3. The computer-implemented method of claim 1, wherein the first interface further includes:

a second column that includes a second column heading indicating a second value of the first field-value pair; and

a second aggregated metric that corresponds to each of the first column and the first row and indicates a second number of events included in a second subset of the set of events, wherein each event included in the second subset of the set of events occurred within the first time increment and the first field-value pair for each event included in the second subset of the set of events includes the second value.

4. The computer-implemented method of claim 3, wherein the first row of the first interface includes:

a first cell that displays the first aggregated metric and is aligned with the first column;

a second cell that displays the second aggregated metric and is aligned with the second column; and

a third cell that displays the first time increment.

5. The computer-implemented method of claim 1, wherein the first interface further includes:

a second row indicating a second time increment; and

a second aggregated metric that corresponds to each of the first column and the second row and indicates a second number of events included in a second subset of the set of events, wherein each event included in the second subset of the set of events occurred within the second time increment and the first field-value pair for each event included in the second subset of the set of events includes the first value.

6. The computer-implemented method of claim 5, wherein the first row includes a first cell and a second cell and the second row includes a third cell and a fourth cell, wherein:

the first cell displays the first time increment;

the second cell displays the first aggregated metric and is aligned with the second column;

a third cell displays the second time increment; and

the fourth cell displays the second aggregated metric and is aligned with the first column.

7. The computer-implemented method of claim 1, wherein the first interface further includes:

a plurality of columns that includes the first column, wherein each of the plurality of columns includes a separate heading indicating a separate value of the first field-value pair; and

a plurality of aggregated metrics that includes the first aggregated metric, wherein each of the plurality of metrics corresponds to the first row and one of the plurality of columns and indicates a number of events included in a separate subset of events.

8. The computer-implemented method of claim 1, wherein the first interface further includes:

a plurality of time increments that includes the first time increment;

a plurality of rows that includes the first row, wherein each of the plurality of rows indicates one of the plurality of time increments; and

a plurality of aggregated metrics that includes the first aggregated metric, wherein each of the plurality of metrics corresponds to one of the plurality of rows and the first column and indicates a number of events included in a separate subset of events.

9. The computer-implemented method of claim 1, wherein the second interface includes a listing of each event included in the subset of the set of events.

10. The computer-implemented method of claim 1, wherein the second interface corresponds to the first time increment, and includes:

a second column that includes a second column heading indicating the first value of the first field-value pair;

a second row indicating a second time increment that is a narrowed time metric of the first time increment; and

a second aggregated metric that corresponds to each of the second column and the second row and indicates a second number of events included in a second subset of the set of events, wherein each event included in the second subset of the set of events occurred within the second time increment, the first field-value pair for each event included in the second subset of the set of events includes the first value, and the second subset of the set of events is a subset of the first subset of the set of events.

11. The computer-implemented method of claim 10, wherein the second interface further includes:

a third row indicating a third time increment that is another narrowed time metric of the first time increment and does not overlap with the second time increment; and

a third aggregated metric that corresponds to each of the second column and the third row and indicates a third number of events included in a third subset of the set of events, wherein each event included in the third subset of the set of events occurred within the third time increment, the first field-value pair for each event included in the third subset of the set of events includes the first value, and the second and third subsets of the set of events are disjoint subsets of the first subset of the set of events.

12. The computer-implemented method of claim 1, wherein the user selection comprises selecting an option in a menu of options corresponding to the first row, the options displayed in the menu including a view events option that is selectable to cause the second interface to display a listing of the events included in the first subset of the set of events.

13. The computer-implemented method of claim 1, wherein the user selection comprises selecting an option in a menu of options corresponding to the first row, the options displayed in the menu including a narrow time range option that is selectable to cause the second interface to include a plurality of additional rows, wherein each of the plurality of the additional rows indicates a different sub range of the first time increment.

14. The computer-implemented method of claim 1, further comprising:

generating the set of the events based on a search query that indicates a field of the first field-value pair, wherein the search query is in a pipelined search language.

15. The computer-implemented method of claim 1, wherein the user selection comprises selecting an option in a menu corresponding to the first row, the menu displaying a time duration that encompasses the first time increment.

16. The computer-implemented method of claim 1, further comprising:

generating the set of the events based on a search that applies a late-binding schema to raw machine data included in events include in another set of events, wherein the set of events is a subset of the other set of events.

17. The computer-implemented method of claim 16, further comprising:

generating the first subset of the set of the events based on a comparison between the first time increment and a timestamp included in each event included in the first subset of the set of events.

18. The computer-implemented method of claim 1, wherein a user employs an input point to provide the user selection, and the method further comprises:

emphasizing the first row responsive to detection of the input pointer over at least one of the first aggregated metric or the first time increment.

19. The computer-implemented method of claim 1, further comprising:

for each event included in the first subset of events, extracting the first value from a portion of raw machine data of the event, wherein the portion of the raw machine data is associated with the first field-value pair of the event.

20. The computer-implemented method of claim 1, further comprising:

for each event included in the first subset of events, employing a late-binding schema to extract the first value from a portion of raw machine data of the event.

21. A system comprising:

one or more processors; and

one or more computer-readable storage media containing instructions which, in response to execution by the one or more processors, cause the one or more processors to perform a method comprising;

causing display of a first interface that includes; and

a first column that includes a first column heading indicating a first value of a first field-value pair of the plurality of field-value pairs;

a first row indicating a first time increment; and

a first aggregated metric that corresponds to each of the first column and the first row and indicates a first number of events included in a first subset of the set of events, wherein each event included in the first subset of the set of events occurred within the first time increment and the first field-value pair for each event included in the first subset of the set of events includes the first value;

causing display of a second interface, in response to a user selection of the first row, wherein the second interface is associated with the first row.

22. The system of claim 21, wherein the method further comprises:

receiving a search query; and

generating the set of the events based on the received search query, wherein each event included in the set of events reflects activity in an information technology environment of at least one computing system.

23. The system of claim 21, wherein the first interface further includes:

a second column that includes a second column heading indicating a second value of the first field-value pair; and

a second aggregated metric that corresponds to each of the first column and the first row and indicates a second number of events included in a second subset of the set of events, wherein each event included in the second subset of the set of events occurred within the first time increment and the first field-value pair for each event included in the second subset of the set of events includes the second value.

24. The system of claim 21, wherein the first row of the first interface includes:

a first cell that displays the first aggregated metric and is aligned with the first column;

a second cell that displays the second aggregated metric and is aligned with the second column; and

a third cell that displays the first time increment.

25. The system of claim 21, wherein the first interface further includes:

a second row indicating a second time increment; and

a second aggregated metric that corresponds to each of the first column and the second row and indicates a second number of events included in a second subset of the set of events, wherein each event included in the second subset of the set of events occurred within the second time increment and the first field-value pair for each event included in the second subset of the set of events includes the first value.

26. One or more non-transitory computer-storage media having executable instructions, which, when executed by a computing device, cause the computing device to perform a method comprising:

causing display of a first interface that includes; and

a first column that includes a first column heading indicating a first value of a first field-value pair of the plurality of field-value pairs;

a first row indicating a first time increment; and

a first aggregated metric that corresponds to each of the first column and the first row and indicates a first number of events included in a first subset of the set of events, wherein each event included in the first subset of the set of events occurred within the first time increment and the first field-value pair for each event included in the first subset of the set of events includes the first value;

causing display of a second interface, in response to a user selection of the first row, wherein the second interface is associated with the first row.

27. The one or more computer-storage media of claim 26, wherein the first row includes a first cell and a second cell and the second row includes a third cell and a fourth cell, wherein:

the first cell displays the first time increment;

the second cell displays the first aggregated metric and is aligned with the second column;

a third cell displays the second time increment; and

the fourth cell displays the second aggregated metric and is aligned with the first column.

28. The one or more computer-storage media of claim 26, wherein the first interface further includes:

a plurality of columns that includes the first column, wherein each of the plurality of columns includes a separate heading indicating a separate value of the first field-value pair; and

a plurality of aggregated metrics that includes the first aggregated metric, wherein each of the plurality of metrics corresponds to the first row and one of the plurality of columns and indicates a number of events included in a separate subset of events.

29. The one or more computer-storage media of claim 26 wherein the first interface further includes:

a plurality of time increments that includes the first time increment;

a plurality of rows that includes the first row, wherein each of the plurality of rows indicates one of the plurality of time increments; and

a plurality of aggregated metrics that includes the first aggregated metric, wherein each of the plurality of metrics corresponds to one of the plurality of rows and the first column and indicates a number of events included in a separate subset of events.

30. The one or more computer-storage media of claim 26, wherein the second interface includes a listing of each event included in the subset of the set of events.