Splunk Search

Make line chart from 2 multivalue fields

arielamar123
Loves-to-Learn

Hi, 

I have 2 multivalue fields I want to make a simple line chart out of them. 
Each event looks like this 
x: [0.1,0.2,0.3,0.4,0.5] , y: [1.7, 1.4, 2.4, 5.5 ,4.7]
 Where x and y are multivalue fields in the event. 

The line chart should be an average graph of those values in the selected time range.

I tried using mvexpand and it didn't work.

Labels (2)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
| eval xy=mvzip(x,y,"!")
| mvexpand xy
| eval x=mvindex(split(xy,"!"),0)
| eval y=mvindex(split(xy,"!"),1)
| fields - xy
0 Karma

arielamar123
Loves-to-Learn

I ran your query , it did nothing , the event is the same as before and I can't create a line chart out of those fields.

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

It would probably help if you gave a bit more detail about your data and your search

0 Karma

arielamar123
Loves-to-Learn

My index gets the following events of this kind: 
{
x: [1,2,3,4,5],
y:[7,4,1,8,3]
}

{
x: [1,2,3,4,5],
y:[5,1,7,8,2]
}


I want to build a line chart of y as function of x :   f(x) = y 
x values are always the same and y values are changing as function of time.

The line chart I want is the average y values for each matching x value along the selected time range.


0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

Still not a lot to go on - assuming you have already extracted x and y as multi-value fields, and that each event has a _time field, try this

| eval xy=mvzip(x,y,"!")
| mvexpand xy
| eval x=mvindex(split(xy,"!"),0)
| eval y=mvindex(split(xy,"!"),1)
| fields - xy
| xyseries _time x y
0 Karma
Get Updates on the Splunk Community!

Observability | How to Think About Instrumentation Overhead (White Paper)

Novice observability practitioners are often overly obsessed with performance. They might approach ...

Cloud Platform | Get Resiliency in the Cloud Event (Register Now!)

IDC Report: Enterprises Gain Higher Efficiency and Resiliency With Migration to Cloud  Today many enterprises ...

The Great Resilience Quest: 10th Leaderboard Update

The tenth leaderboard update (11.23-12.05) for The Great Resilience Quest is out >> As our brave ...