Create a bullet graph query

To create a bullet graph, use a query that returns data in the correct format.

Query syntax

Use this syntax to generate a bullet graph.

... | fields <metric_title> <metric_value> <range_low> <range_med> <range_high> [target]

Query components

<metric_title>

Required

This field has values representing the metric you are tracking.

<metric_value>

Required

Use a <stats_function> to aggregate values in the metric that you are tracking.

range_low range_med range_high

Required

Use these three ranges to show context for the metric. For example, the ranges can indicate minimal, moderate, or high customer satisfaction ratings. Typically, these ranges are predefined in a lookup.

target

Optional

A target adds context to the metric. You can use a value indicating past results or a projected goal. Typically, the target is predefined in a lookup.

Search results data format

After running the query, check the Statistics tab. The results table should include columns representing the metric title, current value, ranges, and an optional target.

Make sure that the results table has columns for required fields in this order.

First	Second	Third	Fourth	Fifth	Sixth
<metric_title>	<metric_value>	range_low	range_med	range_high	target (optional)

Query example

Here is an example bullet graph query that aggregates sales values in different metric categories.

inputlookup sales_data.csv | stats sum(value) by metric  | lookup sales_goals_by_metric metric | fields metric sum(value) range_low range_med range_high

This query uses two lookups to aggregate values by type. First, it loads field names and values for each metric from the sales_data lookup file.

sales_data

metric,value
Revenue,1000
Distinct Users,100
Revenue,700
Distinct Users,200
Distinct Users,600
Distinct Sessions,2000
Revenue,300
Distinct Sessions,3500
Distinct Users,100

The query also uses the sales_goals_by_metric lookup table to get ranges for each metric.

sales_goals_by_metric

metric,range_low,range_med,range_high,target
Revenue,1500,2500,3500,3000
Distinct Users,500,800,1000,700
Distinct Sessions,2000,4000,6000,5000

The query generates the following results table.