Math operations in widget Metrics

Graylog Central (peer support)
1

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 ?

2

Anyone has an idea please if this is feasable ?

3

Please use pipeline rule to calcucale Math operation and store result in new field. Then use this new field for widget.