Dashboards & Visualizations

splunk 6.1.2 + using sparkline and naming the column headers

HattrickNZ
Motivator

I have the following search, search1:

...| chart avg(c84150606) as "avg(CONNECTED_RATIO)" sparkline(avg(CONNECTED_RATIO), 15m) as CONNECTED_RATIO by userLabel

this gives me this stats1 in the stats tab, but the sparkline is not showing:

userLabel   avg(CONNECTED_RATIO)    CONNECTED_RATIO
MSC01HAM    91.138624    <SPARK_LINE_NOT_SHOWING>
MSCKPR  84.608529    <SPARK_LINE_NOT_SHOWING>

with this search search2

...| chart avg(c84150606) sparkline(avg(c84150606), 15m) as CONNECTED_RATIO by userLabel

I can get the sparkline to show in stats2 in the stats tab

userLabel   avg(c84150606)  CONNECTED_RATIO
MSC01HAM    91.138624   <SPARK_LINE_IS_SHOWING>
MSCKPR  84.608529   <SPARK_LINE_IS_SHOWING>

but I in stats2 I want the 2nd column header avg(c84150606) to be avg(CONNECTED_RATIO).

How can I achieve this?

0 Karma
1 Solution

ppablo
Retired

You can also try using the rename command:

...| chart avg(c84150606) sparkline(avg(c84150606), 15m) as CONNECTED_RATIO by userLabel | rename avg(c84150606) as avg(CONNECTED_RATIO)

http://docs.splunk.com/Documentation/Splunk/6.2.2/SearchReference/Rename

View solution in original post

0 Karma

ppablo
Retired

You can also try using the rename command:

...| chart avg(c84150606) sparkline(avg(c84150606), 15m) as CONNECTED_RATIO by userLabel | rename avg(c84150606) as avg(CONNECTED_RATIO)

http://docs.splunk.com/Documentation/Splunk/6.2.2/SearchReference/Rename

0 Karma

HattrickNZ
Motivator

thanks, tried rename every which way but that way 🙂 you should edit your answer so i can accpet it or can i accept it as is?

ppablo
Retired

Hey @HattrickNZ

Sorry I just revisited this post again now. I converted the comment to an answer for acceptability 🙂 cheers and happy Friday!

Patrick

0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.
Get Updates on the Splunk Community!

.conf25 Global Broadcast: Don’t Miss a Moment

Hello Splunkers, .conf25 is only a click away.  Not able to make it to .conf25 in person? No worries, you can ...

Observe and Secure All Apps with Splunk

 Join Us for Our Next Tech Talk: Observe and Secure All Apps with SplunkAs organizations continue to innovate ...

What's New in Splunk Observability - August 2025

What's New We are excited to announce the latest enhancements to Splunk Observability Cloud as well as what is ...