I have been asked by management to provide a dashboard that shows the total connection duration for our remote VPN workforce.
I do have the VPN connection durations from our VPN concentrator logs extracted into two integer fields :
- connection_duration_hours (number of hours)
- connection_duration_minutes (number of minutes)
For each user, the total connection duration in minutes would be :
(sum(connection_duration_hours) x 60) + sum(connection_duration_minutes)
My question is, is it possible to do such math operations (e.g. multiplication) in order to calculate this using the Graylog widget Metrics ?