Query Results | Honeycomb

Query Results

In Query Results, any VISUALIZE chart(s) displays first. Below, a series of tabs for further analysis appears, including:

Overview 

The Overview tab displays a summary table based on your query. If your query includes a GROUP BY clause, then the summary reflects a summary of grouped fields.

BubbleUp 

The BubbleUp tab activates after selecting an area in a chart or heatmap. This selection creates a comparison between the selection and all other results, or the baseline. These comparisons are represented as charts.

A dataset or environment has many fields. BubbleUp represents each field with a chart.

The charts divide into two groups:

  • Dimensions contain fields with categorical or ordinal values
  • Measures contain fields with numeric values

Each chart categorizes the data into two groups:

  • Selection, rendered in yellow on the right side of a value, contains the points in the area selected in the heatmap.
  • Baseline, rendered in blue on the left side of a value, contains all the points outside of the area selected.
BubbleUp dimensions chart example with annotations

The title of the chart is the name of the field.

In the upper right corner, the two donut charts display a ratio of how often the field is found in the data. A field and its values may not be populated in a dataset or environment.

Hover over the title and donut charts to display a tooltip with the full field name and a percentage of how often the field appears in the Selection (yellow) and Baseline (blue).

The bar chart displays each value in bar form, which represents its frequency in the Selection or in the Baseline. The height of each bar is proportional to the number of times the value occurs in the results of the query. The bar chart displays a maximum of seventy-five values, a subset of both Selection and Baseline values.

Hover over the bar for a value, to display a tooltip with its full value name and a percentage of how often the value appears in the Selection and Baseline.

BubbleUp dimension bar chart value tooltip when hovered

A field may contain largely unique values. These are sometimes referred to as nominal data. The tooltips for nominal columns show the exact number of occurrences instead of a percentage in the Selection or the Baseline. For example, events that capture a span in a trace maintain a unique ID for the span in the trace.span_id column.

BubbleUp dimension with nominal values that show a value occurred 1 time in the baseline and 0 times in the selection

Click on a value, or a pair of bars, to display an action menu to take further actions. For charts in the Dimensions section, this actions menu appears:

BubbleUp dimension bar chart value action menu when clicked
Group by Field
Adds a GROUP BY clause and re-runs the query. Select Results to view a summary of grouped fields below the heatmap.
Show only where field is value
Adds a WHERE clause to filter with <field> = <value> and re-runs the query.
Show only where field is not value
Adds a WHERE clause to filter with <field> != <value> and re-runs the query.
Copy field name
Copies the field name to your OS clipboard.

For charts in the Measures section, this actions menu appears:

BubbleUp measures histogram chart value action menu when clicked
Show only where field less than
Adds a WHERE clause to filter with <field> < <value> and re-runs the query.
Show only where field greater than
Adds a WHERE clause to filter with <field> > <value> and re-runs the query.

Correlations 

The Correlations tab consists of a dropdown window that displays the selected data source, a Filter search box, and up to the first six saved queries from the selected data source.

Screenshot showing the Correlations tab display with a Service Health board selected and a filter of service.name=frontend

Each query contains one or more chart visualization(s) and a bulleted list icon. Hover over the bulleted list icon to reveal the query’s name and composition, and an option to open the query in a new tab. Selecting anywhere in the expanded query details opens the query in a new tab.

Screenshot showing display with query name, link to Open Query in new tab, and query details

Traces 

The Traces tab displays up to 10 traces with the slowest spans that match your query’s filters. Click to a trace.

Events 

The Events table shows the raw data from the current query, ignoring the query’s aggregates, GROUP BY, and ORDER BY fields. Each column represents a field from your dataset. Each row represents a span with associated values.

Query Builder with Events tab selected and Events table displayed

Field List 

The list of fields on the left displays fields that have data for this query. This table does not show all fields in the dataset. If a field is not visible, no spans in the query results have data for that field. Use the Field Search box to search for the name of a particular field within the field list.

Field Filter 

Control which fields are visible in the table by selecting the checkbox beside each field in the list of fields. Only the selected fields will appear in the Events table. A summary at the top of the field list will display the number of All fields in parenthesis, and if applicable, the number of Current selected fields in parenthesis. Select ALL to reset the display and to show all fields in the Events table.

Field List display with three fields selected

Download Your Data 

Download your data by choosing the CSV or JSON option above the list of fields. With this method, the maximum number of downloadable rows is 1,000.

Tracing Details Shortcut 

If your dataset is a tracing dataset, there is a small icon to the left of every Events row. Select this icon to display the details of the trace, which contains the span represented by that row.

Tracing icon example

Load More Details 

Use Load more rows at the bottom right of the Events table to load more data rows if available.

Load more rows button at bottom of table