Rounding in Pipelines

[shoothub]

I’ve already helped with similar problem, it can also work for you, please check my previous post:

Pipeline Rule: convert seconds to something readable

Very interesting problem, but with simple solution. I’ve created and tried this snippet and it works as expected. I’ve used function parse_unix_milliseconds to parse number of vpn duration in seconds as unix time. After that I only extracted hours, minutes and seconds using functions hourOfDay, minuteOfDay and secondOfDay and concat in one string. let vpn_duration = parse_unix_milliseconds(to_long($message.pulse_connectsec) * 1000); let vpn_hours = vpn_duration.hourOfDay; let vpn_minutes = vpn_…