I want to create a dashboard panel with last 7 days duration, start time, end time and average duration, max duration for a task. I am able to get the duration in an array and then get the average duration, max duration, but how do I retain the start time and end time ?
|fieldsAdd duration_min = round(round(toDouble(unixSecondsFromTimestamp(right.endtmsp)), decimals:6)- round(toDouble(unixSecondsFromTimestamp(starttmsp)), decimals:6))/60
|summarize d=collectArray(duration_min)
|fields a = record(value = d[], arraymax(d), arraymin(d),arrayAvg(d))
|expand a
how do I retain the start time and end time?
