Enable Table panel to display durations

Description

User can define a column that computes the duration between two dates(<date column>, [date column]). Something like:

duration(lastEventTime, now())
duration(firstEventTime) /[date] defaults to now()/
duration(firstEventTime, ackTime) /* would set col head to NOC Response Time */

Perhaps the the technique allows the user to pick a "from" column, such as ackTime, then the select an "aggregation function" called duration that then allows you to pick the "to" column with default as now().

Lucidchart Diagrams

Activity

Show:

Benjamin Reed December 12, 2018 at 3:00 PM

Merged to develop.

Benjamin Reed December 5, 2018 at 9:56 PM

I also added the "short" style as well, it was a pretty easy addition.

These frontend changes are part of the ranger/helm-3-improvements branch that will include a few other HELM-* issues as well. WIP here: https://github.com/OpenNMS/opennms-helm/tree/ranger/helm-3-improvements

David Hustace December 4, 2018 at 8:33 PM

Sounds great.

Benjamin Reed December 4, 2018 at 5:28 PM

It’s using the moment.js formatting so it will say “x weeks ago” and so on, but same idea yes.

David Hustace December 4, 2018 at 5:27 PM

If relative time means that the time between "now" and the date indicated in the field, I believe that acceptable.  Will it be a value that is sortable with a formatting of 5w, 7d, 3m, etc?

Fixed

Details

Assignee

Reporter

Components

Sprint

Fix versions

Priority

PagerDuty

Created November 8, 2018 at 6:24 PM
Updated March 26, 2019 at 12:48 PM
Resolved December 12, 2018 at 3:00 PM