Executing search commands based on selection on field values displayed in a statistics table
In embodiments of statistics value chart interface cell mode drill down, a first interface displays in a table format that includes columns each with field values of an event field, and each column having a column heading of a different one of the event fields, and includes rows each with one or more of the field values, each field value in a row associated with a different one of the event fields, and having an aggregated metric that represents a number of events with field-value pairs that match all of the field values listed in a respective row and the corresponding event fields listed in the respective columns. A cell can be emphasized that includes one of the field values in a row that corresponds to one of the different event fields in a column, and in response, a menu displays options to transition to a second interface.
1. A computer-implemented method, comprising:
causing display of a table within a first interface, wherein the table is associated with a plurality of fields for a set of events and includes:
a plurality of rows, wherein a first row of the plurality of rows includes a plurality of field cells and a statistics cell that is separate from the plurality of field cells, and wherein
each field cell of the plurality of field cells uniquely corresponds to a field of the plurality of fields and displays a value for a corresponding field, such that each field cell of the plurality of fields is associated with a field-value pair and the first row is associated with a plurality of field-value pairs, and
the statistics cell displays an aggregated metric based on a cardinality of a first subset of the set of events, wherein each event included in the first subset of the set of events is associated with each of the plurality of field-value pairs associated with the first row;
in response to receiving a selection of a first field cell from the plurality of field cells in the first row, causing display of a plurality of selectable options; and
in response to receiving a selection of a first option of the plurality of selectable options, causing display of a second subset of the set of events in a second interface that is separate from the first interface, the second subset of the set of events being identified by the first option, the first field cell, and a first field-value pair of the plurality of field-value pairs that is associated with the first field cell.
2. The method as recited in claim 1 , wherein the aggregated metric includes an averaged value based on the first subset of the set of events.
3. The method as recited in claim 1 , wherein the set of events satisfies a received search query.
4. The method as recited in claim 1 , wherein the second interface is an events interface that includes a second plurality of rows and displays the second subset of the set of events within an events list, such that each event of the second subset of the set of events is displayed within a corresponding row of the second plurality of rows, and wherein an identification of the second subset of the set of events is based on events of the second subset of the set of events being associated with the value displayed in the first field cell.
5. The method as recited in claim 1 , wherein the second interface is an events interface that includes a second plurality of rows and displays the second subset of the set of events within an events list, such that each event of the second subset of the set of events is displayed within a corresponding row of the second plurality of rows, and wherein an identification of the second subset of the set of events is based on events of the second subset not being associated with the first field-value pair.
6. The method as recited in claim 1 , wherein the table further includes a plurality of columns, and each of the plurality of columns uniquely correspond to one of the plurality of fields and each of the plurality of fields is selected for inclusion in the table.
7. The method as recited in claim 1 , wherein the table further includes a plurality of columns, and each of the plurality of columns uniquely correspond to one of the plurality of fields and is references in a command of a search query that is satisfied by each event included in the set of events.
8. The method as recited in claim 1 , wherein an inclusion of each event included in the second subset of the set of events is based on the first field-value pair.
9. The method as recited in claim 1 , wherein the second interface is an events interface that includes a second plurality of rows and displays the second subset of the set of events within an events list, such that each event of the second subset of the set of events is displayed within a corresponding row of the second plurality of rows, and wherein an identification of the second subset of the set of events is based on events of the second subset of the set of events have a second field-value pairs of the plurality of field-value pairs that is to a left of the first field cell.
10. The method as recited in claim 1 , wherein a first event of the second subset of the set of events is excluded from the first subset of the set of events.
11. The method as recited in claim 1 , wherein:
the second interface is an events interface that includes a second plurality of rows and displays the second subset of the set of events within an events list, such that each event of the second subset of the set of events is displayed within a corresponding row of the second plurality of rows, and wherein an identification of the second subset of the set of events is based on events of the second subset of the set of events being associated with the value displayed in the first field cell; or
the second interface is the first interface displayed excluding the first field-value pair.
12. The method as recited in claim 1 , further comprising:
receiving a user selection of the first field cell, wherein the user selection emphasizes the first field cell and the selection of the first field cell is while the first field cell is emphasized from the user selection.
13. The method as recited in claim 1 , wherein the plurality of selectable options is displayed within a menu and includes a new search option that causes a new search query to be run resulting in a new set of events that includes at least one event excluded from the set of events and included in the second subset of the set of events.
14. The method as recited in claim 1 , wherein the plurality of selectable options is displayed within a menu and includes a view events option that is selectable to transition the first interface to the second interface and the second subset of the set of events includes events with field-value pairs that match the first field-value pair.
15. The method as recited in claim 1 , wherein the plurality of selectable options is displayed within a menu and includes an other events option that is selectable to transition the first interface to the second interface and the second subset of the set of events includes events with field-value pairs that exclude the first field-value pair.
16. The method as recited in claim 1 , wherein the plurality of selectable options is displayed within a menu and includes an exclude from results option that is selectable to transition the first interface to the second interface and the second subset of the set of events includes events with field-value pairs that exclude the first field-value.
17. The method as recited in claim 1 , wherein the plurality of selectable options is displayed within a menu and includes a new search option that is selectable to create a new search based on the first field-value pair.
18. The method as recited in claim 1 , wherein:
the plurality of selectable options is displayed within a menu and includes at least a view events option, an other events option, an exclude from results option, and a new search option;
the view events option being selectable is selectable to transition the first interface to the second interface and the second subset of the set of events includes events with field-value pairs that match the first field-value pair;
the other events option being selectable to transition the first interface to the second interface and the second subset of the set of events includes events with field-value pairs that exclude the first field-value pair;
the exclude from results option being selectable to transition the first interface to the second interface and the second subset of the set of events includes events with field-value pairs that exclude the first field-value; and
the new search option being is selectable to create a new search based on the first field-value pair.
19. The method as recited in claim 1 , wherein the plurality of selectable options is displayed within a menu and the menu further displays the first field-value pair.
20. The method as recited in claim 1 , wherein the plurality of selectable options is displayed within a menu and the menu further displays a second field-value pair of the plurality of field-value pairs, the second field-value pair being associated with a second field cell of the plurality of field cells, and the second field cell is to a left of the first field cell.
21. The method as recited in claim 1 , wherein the plurality of selectable options is displayed within a menu and the menu further displays a second field-value pair of the plurality of field-value pairs, the second field-value pair being associated with a second field cell of the plurality of field cells.
22. The method as recited in claim 1 , further comprising:
in response to a detection of an input pointer over the first field cell, emphasizing the first field cell.
23. The method as recited in claim 1 , further comprising:
in response to a detection of an input pointer over the first field cell, highlighting the first field cell.
24. The method as recited in claim 1 , wherein the set of events are initially derived from collected data that comprises at least one of raw data, machine data, performance data, log data, diagnostic information, transformed data, or mashup data combined from multiple sources.
25. The method as recited in claim 1 , wherein the set of events are returned as a result of a search performed using a late-binding schema on data originally collected from one or more sources.
26. The method as recited in claim 1 , wherein each event included in the set of events each comprise a portion of raw data that is associated with a timestamp indicating a respective point in time.
27. A computer-implemented system, comprising:
one or more processors; and
one or more computer-readable media having executable instructions embodied thereon, which, when executed by the one or more processors, cause the one or more processors to perform a method comprising:
causing display of a table within a first interface, wherein the table is associated with a plurality of fields for a set of events and includes:
a plurality of rows, wherein a first row of the plurality of rows includes a plurality of field cells and a statistics cell that is separate from the plurality of field cells, and wherein
each field cell of the plurality of field cells uniquely corresponds to a field of the plurality of fields and displays a value for a corresponding field, such that each field cell of the plurality of fields is associated with a field-value pair and the first row is associated with a plurality of field-value pairs, and
the statistics cell displays an aggregated metric based on a cardinality of a first subset of the set of events, wherein each event included in the first subset of the set of events is associated with each of the plurality of field-value pairs associated with the first row;
in response to receiving a selection of a first field cell from the plurality of field cells in the first row, causing display of a plurality of selectable options; and
in response to receiving a selection of a first option of the plurality of selectable options, causing display of a second subset of the set of events in a second interface that is separate from the first interface, the second subset of the set of events being identified by the first option, the first field cell, and a first field-value pair of the plurality of field-value pairs that is associated with the first field cell.
28. The system as recited in claim 27 , wherein a first event of the second subset of the set of events is excluded from the first subset of the set of events.
29. The system as recited in claim 27 , wherein:
the plurality of selectable options is displayed within a menu and includes at least a view events option, an other events option, an exclude from results option, and a new search option;
the view events option being selectable is selectable to transition the first interface to the second interface and the second subset of the set of events includes events with field-value pairs that match the first field-value pair;
the other events option being selectable to transition the first interface to the second interface and the second subset of the set of events includes events with field-value pairs that exclude the first field-value pair;
the exclude from results option being selectable to transition the first interface to the second interface and the second subset of the set of events includes events with field-value pairs that exclude a first field value of the first field-value pair; and
the new search option being is selectable to create a new search based on the first field-value pair.
30. One or more non-transitory computer-readable, non-volatile storage memory comprising stored instructions that are executable to cause one or more processors to perform operations comprising:
causing display of a table within a first interface, wherein the table is associated with a plurality of fields for a set of events and includes:
a plurality of rows, wherein a first row of the plurality of rows includes a plurality of field cells and a statistics cell that is separate from the plurality of field cells, and wherein
each field cell of the plurality of field cells uniquely corresponds to a field of the plurality of fields and displays a value for a corresponding field, such that each field cell of the plurality of fields is associated with a field-value pair and the first row is associated with a plurality of field-value pairs, and
the statistics cell displays an aggregated metric based on a cardinality of a first subset of the set of events, wherein each event included in the first subset of the set of events is associated with each of the plurality of field-value pairs associated with the first row;
in response to receiving a selection of a first field cell from the plurality of field cells in the first row, causing display of a plurality of selectable options; and
in response to receiving a selection of a first option of the plurality of selectable options, causing display of a second subset of the set of events in a second interface that is separate from the first interface, the second subset of the set of events being identified by the first option, the first field cell, and a first field-value pair of the plurality of field-value pairs that is associated with the first field cell.