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

[dfigurello]

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,

[lguinn2]

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.

[dfigurello]

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

Tks.