Math operations in widget Metrics

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 ?

Anyone has an idea please if this is feasable ?

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

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.