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. For example, say we're running a query like:
| parse "HTTP/1.1\" * * * " as status_code, size, response_time
| timeslice 5m
| avg(response_time), count by _timeslice
Generally, this query would produce a bar or column chart that looks a bit like this:
But with a combo chart, we can set the _count volume to display as a line chart on a second axis, so the count value is represented by a line instead of a bar:
Then you can add combo chart panels to a dashboard or view them in the Aggregates pane.
To create a combo chart
- Run a query.
- In the Aggregates tab, choose the Column Chart icon to display the search results.
- To add a second axis, click the Settings icon in the Aggregates pane, then choose Change Series.
- 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.
- Click Save.
The combo chart is built and displayed.