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:

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)).

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.

   

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.

   

   The combo chart is built and displayed.