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 Highlights | January 2023 Newsletter

 January 2023New Product Releases Splunk Network Explorer for Infrastructure MonitoringSplunk unveils Network ...

Security Highlights | January 2023 Newsletter

January 2023 Splunk Security Essentials (SSE) 3.7.0 ReleaseThe free Splunk Security Essentials (SSE) 3.7.0 app ...

Platform Highlights | January 2023 Newsletter

 January 2023Peace on Earth and Peace of Mind With Business ResilienceAll organizations can start the new year ...