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,
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.
lguinn ,
is it impossible to create a predict in this case ?
Tks.