Graph Settings | Honeycomb

Graph Settings

Honeycomb has several types of graphs, to explore your query results in multiple ways. Customize your display and how you interact with your data by using:

Access Graph Settings 

The Markers Menu, Download Query Results, and Graph Settings menu icons appear after a query runs in Query Builder. These three icons - text bubble, download, and gear respectively - appear directly below the time picker and the Query Builder interface.

Select each icon to open its menu options.

Markers text bubble icon, Download Query Results icon, and Graph Settings gear icon display

Markers Settings Menu 

Control how Markers display on the query results, either by filtering or changing the markers’ appearance.

Hide or Show Markers 

Hide or show markers in the results display either by using the Graph Settings menu or the m keyboard shortcut.

Filter Markers 

Access the Filter Markers modal either by using the Graph Settings menu or the l keyboard shortcut. This option label remains static in the menu.

Then, the Filter Markers modal appears with the option to Filter by value with a search box to enter terms, or Filter by type with a list of facets to select. Select Submit to update the display of markers.

Download Query Results Menu 

These download options remain static in the menu.

Download CSV 

Use Download CSV to download the query results in .csv format.

Note
We may process or alter the data returned in the CSV to prevent CSV injection vulnerabilities. For more information, contact Support via support.honeycomb.io or email at support@honeycomb.io.

Download JSON 

Use Download JSON to download the query results in JSON format.

Graph Settings Menu 

These Graph Settings menu options control the appearance of the query results. Select an option to apply it to the current query results. The selected option in the menu then updates to display the opposite of that option. For example, Display Line Graphs becomes Display Stacked Graphs.

First set of Graph Settings menu Second set of Graph Settings menu

Prefer Overlaid Charts 

Honeycomb renders a separate chart for every VISUALIZE clause in your query by default. Checking Prefer Overlaid Charts combines any visualized AVG, MIN, MAX, and PERCENTILE clauses into a single chart.

Prefer overlaid charts that shows charts rendered together

Supported operations include:

  • AVG
  • MAX
  • MIN
  • P001
  • P01
  • P05
  • P10
  • P25
  • P50
  • P75
  • P90
  • P95
  • P99
  • P999

Charts will not overlay for queries that have a GROUP BY clause. Unsupported operations include:

  • CONCURRENCY
  • COUNT
  • COUNT_DISTINCT
  • GROUP BY (removes overlays)
  • HEATMAP
  • RATE
  • SUM

Display Stacked Graphs or Line Graphs 

Line Graph
[default] Displays each group as a line of values over time. Read the value at a particular time directly from the Y axis on the left side of the graph.
Stacked Graph
Displays groups as stacked colored areas under their line graphs. Each shows a group’s relative contribution to the total. The Y axis reflects the sum of all groups.

Display Log Scale or Linear Scale 

Log Scale
[default] The Y axis of a Log Scale graph increases exponentially. Each Y value increase represents an order of magnitude (10n) change. A Log Scale graph is useful for data with an extremely large range of values.
Note
Log Scale does not work with heatmaps. Instead, use a derived column with the function LOG10($column). This technique is illustrated in the blog entry Handle Unruly Outliers with Log Scale Heatmaps.
Linear Scale
The Y axis of a Linear Scale graph increases by a fixed amount as values increase. It is useful for data with a limited range of expected values.

Display UTC Time X-Axis or Localtime X-Axis 

UTC Time
Displays the X axis in Coordinated Universal Time, the time at 0° longitude. UTC is sometimes referred to as Greenwich Mean Time (GMT). UTC does not observe Daylight Savings Time.
Local Time
Displays the X axis in your browser’s local time.

Omit Missing Values or Fill Missing Values with Zeros 

Omit Missing Values
[default] Interpolates between points when the intervening time buckets have no matching events. Use to display a continuous line graph with no drops to zero.
Fill Missing Values with Zeros
Substitutes zero values for time buckets with no matching events.

Hide or Show Graph Hovers 

Graph Hovers appear in the results display when hovering over a graph. Hide or show Graph Hovers either by using the Graph Settings menu or the w keyboard shortcut. For example, use this setting to remove any obstruction to the overall graph display, or to optimize for screenshot purposes.