Archive
Highlighted

I have a chart with multiple lines and I want to "merge" them.

Explorer

Hi everyone!
Here is my problem:

Thanks to a search, I have multiple lines on the same graph. But now, I want to merge them in a single line.

My search:

index="dashboards" Step=-1 | bucket time span=1s | convert timeformat="%H:%M:%S" ctime(time) AS datelancement | chart values(Test) as res by datelancement, AgentID

I create a chart which gives me two lines (because I have two different AgentID in this case), and the values(Test) gives me, for each of them, a number during the time (date_lancement).

So let's say those two lines are f(x) and g(x), I want to draw (f+g)(x).

Any idea? 😃

Thanks in advance,

nugetchar.

Tags (1)
0 Karma
Highlighted

Re: I have a chart with multiple lines and I want to "merge" them.

SplunkTrust
SplunkTrust

Hi nugetchar

I hope I get you right; I think you will get what you want, if you change the formatting option for your chart to chart type area and stack mode to stacked.

alt text

hope this helps

cheers,

MuS

0 Karma
Highlighted

Re: I have a chart with multiple lines and I want to "merge" them.

Splunk Employee
Splunk Employee

why not removing the AgentId field completely and display a timechart ?

index="dashboards" Step=-1 | timechart span=1s sum(Test) as res

0 Karma