Skip to main content

Chart Search Results

In the Aggregates tab, in addition to the standard table view, you can view search results as a chart, such as a bar or column chart.

Only search results that have been aggregated using a group or aggregate operator can be charted. See Group or Aggregate Operators for a list. 

When charting aggregate results from a query, the grouping function defines the plotted values on the one axis, and the grouping operator determines the values on the other axis. For example, group by _sourceHost produces a bar or point for each host. If you're using multiple group-by functions, a separate bar or point represents each set of grouped results.

Chart aggregate results

Follow the below instructions to chart aggregate the results:

  1. From a search, run an aggregate query.
  2. From the Aggregates tab, click a graph button on the Aggregates tab.
aggregates

For this example, you can see a bar chart, but you can pick from any of the available charting options, see Chart Panel Types for details.

New Visualizations

Clicking the New Visualizations button will enable the new visualizations for your log search chart, also helping you to customize each chart by modifying the available settings and providing a unified experience across the Sumo Logic platforms.

Charts will appear in classic visualization style by default. However, if you choose a new visualization, your selection will be remembered, and any further searches in the same or new tab will always render with the new visualization.

new-visualizations

Data represents the data that has been used to plot chart, Round data point toggle button is used to turn ON/OFF the round off to the value in tooltip, and the Visual Settings options allow you to customize your chart. The other customizing properties include Display Overrides, Axes, Legend, Thresholds, and JSON.

log-query-charts-properties

If you prefer to use the classic visualizations UI, you can do so by clicking the Classic Visualizations button. You'll be asked to confirm your choice, Click Switch to Classic Visualizations to proceed.

switch-to-classic-visualizations

FAQ

Why are the chart options not available?

Your data may be a string data type instead of a number. Most aggregate operators will cast your data to a number, operators like first and last don't. You can cast your data to a number if needed using the num operator.

Example:

_sourceCategory=concierge completed execution
| parse "Execution duration: * s" as duration
| timeslice 5m
| first(duration) as duration by _timeslice
| num(duration)
| sort by duration

For details on casting your data to a string or numeric data type see Casting Data to a Number or String for details.

Legal
Privacy Statement
Terms of Use

Copyright © 2024 by Sumo Logic, Inc.