Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello @ezer_e, can you try with this script:
TableExample:
LOAD [TASK_ID],
CREATED,
FINISHED,
Interval(FINISHED - CREATED, 'hh:mm:ss') as Duration
FROM
[xxxxxxxxxxxxx]
(html, codepage is 1252, embedded labels, table is xxxxxx);
Avg Duration Expression:
=Interval(Avg(Duration), 'hh:mm:ss')
Hope it can help you 🙂
Hello @ezer_e, can you try with this script:
TableExample:
LOAD [TASK_ID],
CREATED,
FINISHED,
Interval(FINISHED - CREATED, 'hh:mm:ss') as Duration
FROM
[xxxxxxxxxxxxx]
(html, codepage is 1252, embedded labels, table is xxxxxx);
Avg Duration Expression:
=Interval(Avg(Duration), 'hh:mm:ss')
Hope it can help you 🙂