Splunk Search

timechart with each line defined by multiple fields

benobviate
Explorer

my search is something like

... | stats avg(weight) by color, shape

which results in :

color shape avg(weight)

blue triangle 30

blue circle 20

green triangle 35

I want to do a timechart with each row as a line. I tried replacing stats with timechart but it gave me an error (I'm assuming is because i have it arranged by two fields. How would I go about doing this? I want a line for blue triangle, blue circle and green triangle. Also, is there a convenient way to name the lane via the first+second field name? (e.g. "blue triangle")

Tags (1)
0 Karma
1 Solution

lguinn2
Legend

Sure, try this

yoursearchhere
| eval color_and_shape = color + " " + shape
| timechart avg(weight) by color_and_shape

View solution in original post

lguinn2
Legend

Sure, try this

yoursearchhere
| eval color_and_shape = color + " " + shape
| timechart avg(weight) by color_and_shape

matthewcanty
Communicator

Spot on. Thanks.

0 Karma

benobviate
Explorer

Thank you so much!! That worked perfectly! 🙂

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

Can’t make it to .conf25? Join us online!

Get Updates on the Splunk Community!

Community Content Calendar, September edition

Welcome to another insightful post from our Community Content Calendar! We're thrilled to continue bringing ...

Splunkbase Unveils New App Listing Management Public Preview

Splunkbase Unveils New App Listing Management Public PreviewWe're thrilled to announce the public preview of ...

Leveraging Automated Threat Analysis Across the Splunk Ecosystem

Are you leveraging automation to its fullest potential in your threat detection strategy?Our upcoming Security ...