Splunk Search

I would like show sparkline from outputlookup table


I would like to improve search performance by preload data into csv or kv-store with sparkline. How do I display sparkline back when I use command inputlookup ?

Thank you

Tags (1)
0 Karma


@karn community would be able to assist you better if you provide more details as to what your current sparkline looks like and what is the data and Splunk query used.

Assuming you are having hourly sparkline. Following is a run anywhere example from Splunk's _internal index:

index=_internal sourcetype=splunkd log_level!=INFO
| stats sparkline(count,1h) as trend by component

In order to save the results of hourly stats. You need to breakdown the process in two parts:

Step 1: Send to outputlookup with hourly aggregate

index=_internal sourcetype=splunkd log_level!=INFO
| bin _time span=1h
| stats count by _time component
| outputlookup test.csv

Step 2: Get sum() of count per hour as sparkline. Use span as 1h for sparkline

| inputlookup test.csv
| stats sparkline(sum(count),1h) as trend by component

Please try out and confirm!

| makeresults | eval message= "Happy Splunking!!!"
0 Karma
Get Updates on the Splunk Community!

Splunk Cloud | Empowering Splunk Administrators with Admin Config Service (ACS)

Greetings, Splunk Cloud Admins and Splunk enthusiasts! The Admin Configuration Service (ACS) team is excited ...

Tech Talk | One Log to Rule Them All

One log to rule them all: how you can centralize your troubleshooting with Splunk logs We know how important ...

Splunk Security Content for Threat Detection & Response, Q1 Roundup

Join Principal Threat Researcher, Michael Haag, as he walks through: An introduction to the Splunk Threat ...