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.
| eval xy=mvzip(x,y,"!") | mvexpand xy | eval x=mvindex(split(xy,"!"),0) | eval y=mvindex(split(xy,"!"),1) | fields - xy
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.
It would probably help if you gave a bit more detail about your data and your search
My index gets the following events of this kind:
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.
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