Bullet Graph

Bullet Graph

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.

Custom viz bullet graph stats table.png

Last modified on 12 August, 2016
Bullet graph installation   Bullet graph components

This documentation applies to the following versions of Bullet Graph: 1.0.0, 1.1.0, 1.2.0, 1.3.0, 1.4.0, 1.5.0


Was this topic useful?







You must be logged into splunk.com in order to post comments. Log in now.

Please try to keep this discussion focused on the content covered in this documentation topic. If you have a more general question about Splunk functionality or are experiencing a difficulty with Splunk, consider posting a question to Splunkbase Answers.

0 out of 1000 Characters