Splunk Search

How to convert m/s to km/h?

Imjusttesting
Explorer

Hey guys, I'm having this syntax here and the incoming data is m/s and i need to convert it to km/h. How can i do it? Below is the syntax.

"MaxSpeed" min(SPEED) as "Min Speed" max(rfid) as rfid by username tripno Sequence | rename username as "Vehicle License No"| eval dur=Stop-Start | where dur>(60) | streamstats count as No | eval "Start Date"=strftime(Start, "%m/%d/%Y") | eval "Start Time"=strftime(Start, "%H:%M:%S") | eval "Stop Date"=strftime(Stop, "%m/%d/%Y") | eval "Stop Time"=strftime(Stop, "%H:%M:%S") | eval "Total Time"=tostring(dur, "duration") | eval "Max Speed"=tostring(round(MaxSpeed, 2)
0 Karma
1 Solution

somesoni2
Revered Legend

Before the eval "Max Speed", add this

| eval MaxSpeed=MaxSpeed*3.6

View solution in original post

somesoni2
Revered Legend

Before the eval "Max Speed", add this

| eval MaxSpeed=MaxSpeed*3.6

Imjusttesting
Explorer

Thanks ... that work

0 Karma
Get Updates on the Splunk Community!

Observability Highlights | January 2023 Newsletter

 January 2023New Product Releases Splunk Network Explorer for Infrastructure MonitoringSplunk unveils Network ...

Security Highlights | January 2023 Newsletter

January 2023 Splunk Security Essentials (SSE) 3.7.0 ReleaseThe free Splunk Security Essentials (SSE) 3.7.0 app ...

Platform Highlights | January 2023 Newsletter

 January 2023Peace on Earth and Peace of Mind With Business ResilienceAll organizations can start the new year ...