Skip to main content

Combo Charts

Combo charts allow you to create bar or column charts with a secondary vertical axis so you can add a separate line as a comparison.

note

The number of data points on a dashboard panel are limited to 1,000, and therefore only 1,000 data points are shown on a chart panel in dashboards.

For example, say we're running a query like:

_sourceCategory=*apache*
| parse "HTTP/1.1\" * * * " as status_code, size, referrer
| timeslice 5m
| avg(size), count by _timeslice

Generally, this query would produce a bar or column chart that looks a bit like this:

Bar chart before combo plot

But with a combo chart, you can set the _count to display as a line chart on a second axis, so the count value is represented by a line instead of a bar. You will be able to see the number of requests over time (_count), against the average number of bytes per request (_avg=avg(size)).

Combo chart

Then you can add combo chart panels to a dashboard or view them in the Aggregates pane.

To create a combo chart:

  1. Run a query.

  2. In the Aggregates tab, choose the Column Chart icon to display the search results.

    Charts - column

  3. To add a second axis, click the Settings icon in the Aggregates pane, then choose Change Series.

  4. In the Change Series dialog box, choose the value you'd like to add as a secondary axis and chart type. In our example, for the _count value, we set:

    • For Chart Type, select Line Chart.
    • For  Vertical Axis, select Secondary Axis.
  5. Click Save.

    Change series

    The combo chart is built and displayed.

Legal
Privacy Statement
Terms of Use

Copyright © 2023 by Sumo Logic, Inc.