Splunk Search

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

dfigurello
Communicator

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,

0 Karma

lguinn2
Legend

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
Communicator

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

Tks.

0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...