topic Avarage time duration in App Development

Avarage time duration

Anonymous — Wed, 03 May 2017 14:11:05 GMT

Hello, Im using this:
Max(${<[TO shipment]>}[Over Date Time]) - Min(${<[TO shipment]>}[Conf.tDate&Time])

to get time duration. Now I would like use result time to get Avarage time for [TO shipment] in my selected data. I tried:

avg (aggr (Max(${<[TO shipment]>}[Over Date Time])-Min(${<[TO shipment]>}[Conf.tDate&Time]),))

but this one dont work. Result in my tab is " - ".

Please, can anybody help me? Sorry, for my english. Thank you for your help.

sunny_talwar — Wed, 03 May 2017 16:39:52 GMT

May be this

Avg(Aggr(Max(${<[TO shipment]>}[Over Date Time]) - Min(${<[TO shipment]>}[Conf.tDate&Time]), [TO shipment]))

Anonymous — Thu, 04 May 2017 07:58:10 GMT

Thank you Sunny, it work.