Add two lines in a chart

[wasifchowdhury]

I have this query and I want to add another data series/line to this chart. How can I do it?

index="eniq_voice"
|where localDn="ManagedElement=TO5CSCF01"
|bucket _time span=15m
|stats max(CPULoad_Total) as CPULoad_Total by localDn _time
|timechart max(CPULoad_Total) as CPULoad_Total

I want to add this to the query with a linechart:
|stats max(CPULoad_Max) as CPULoad_Max by localDn _time
|timechart max(CPULoad_Max) as CPULoad_Max by localDn _time

[Siddharth · Accepted solution]

Hi 

index="eniq_voice"
|where localDn="ManagedElement=TO5CSCF01"
|bucket _time span=15m
|stats max(CPULoad_Total) as CPULoad_Total by localDn _time
|timechart max(CPULoad_Total) as CPULoad_Total max(CPULoad_Max) as CPULoad_Max 


This should help . Basically you can add as much as line you want  see example below

[ITWhisperer]

Does this give you what you want?

index="eniq_voice"
|where localDn="ManagedElement=TO5CSCF01"
|bucket _time span=15m
|stats max(CPULoad_Total) as CPULoad_Total max(CPULoad_Max) as CPULoad_Max by localDn _time
|timechart max(CPULoad_Total) as CPULoad_Total max(CPULoad_Max) as CPULoad_Max

[wasifchowdhury]

Sorry, it doesnt. I dont get any results.