topic Re: How to create scatter graph correlating two data sources of transactions and average CPU usage? in Splunk Search

How to create scatter graph correlating two data sources of transactions and average CPU usage?

dfigurello — Wed, 10 Sep 2014 02:18:20 GMT

Hi Splunkers,

I have two data sources. In the first i have the number of transactions executed grouped by hours. In the second i have the average cpu usage for the same transactions in the same time. I need do correlate the number of transactions with the average cpu usage in a scatter graph (x,y). Is it possible?

E.g>
cpu.csv
time,cpu
00:00,0.3
01:00,025
02:00,0.50
03:00,0.87
04:00,090

transaction.csv
Time,transaction
00:00,50
01:00,60
02:00,70
03:00,87
04:00,25

Finally, I need create a prediction about that information, is it possible using scatter graph?

Cheers,

Re: How to create scatter graph correlating two data sources of transactions and average CPU usage?

lguinn2 — Wed, 10 Sep 2014 03:16:47 GMT

I would probably do something like this

source=cpu.csv OR source=transaction.csv
| eval Time=coalesce(Time,time)
| stats first(cpu) as cpu first(transaction) as xact by Time
| table cpu xact

Then choose the visualization for scatterplot. This does not provide any mechanism for fitting a line to the data.

Re: How to create scatter graph correlating two data sources of transactions and average CPU usage?

dfigurello — Sat, 13 Sep 2014 01:21:40 GMT

lguinn ,
is it impossible to create a predict in this case ?

Tks.