Hi All,
One of our managers wants to be able to produce a list of incidents and have a field there for each one saying how long it has been open for. What's the best way to go about this?
I thought the easiest way to do this would be to add a new field to the incident form and add in the calculated value something like:
var opened = current.opened_at.getDisplayValue();
var now = gs.nowDateTime();
var time = gs.dateDiff(opened, now, true);
My first question is, what performance effect (if any) will this have if it is calculating this value for every incident? If it's going to have a knock on performance issue would i be better off making this a metric instead?
If it isn't going to effect performance, how do i present the resulting seconds in a days/hours/minutes/seconds time field?
