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!

Now Available: Cisco Talos Threat Intelligence Integrations for Splunk Security Cloud ...

At .conf24, we shared that we were in the process of integrating Cisco Talos threat intelligence into Splunk ...

Preparing your Splunk Environment for OpenSSL3

The Splunk platform will transition to OpenSSL version 3 in a future release. Actions are required to prepare ...

Easily Improve Agent Saturation with the Splunk Add-on for OpenTelemetry Collector

Agent Saturation What and Whys In application performance monitoring, saturation is defined as the total load ...