how to calculate average value in specific time range (lets say 5:00 - 7:00) ?

[Patricia_Silva · Accepted solution]

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 🙂