Hi,
Hope someone can help.
I have a table of three columns. (Please see below)
The first is a list of Work Order Numbers. (string)
The second is a list of Asset Numbers that the Work Orders are assigned to. (string)
The third the Report Date, which is a list of dates the Work Orders were raised.
Please can someone tell me a way that I can work out the average time between Report dates for each asset. ie Asset A has an average of XX days between Work Orders, Asset B has an average of XX days between Work Orders etc.
Thanks
Work Order Asset Report Date
100001 A 01-Apr-18
100002 A 04-Apr-18
100003 A 10-Apr-18
100004 A 20-Apr-18
100005 B 02-Apr-18
100006 B 10-Apr-18
100007 B 16-Apr-18
100008 B 20-Apr-18
100009 B 25-Apr-18
100010 B 30-Apr-18
100011 C 01-Apr-18
100012 C 05-Apr-18
100013 C 15-Apr-18
100014 C 22-Apr-18
100015 C 28-Apr-18
100016 C 29-Apr-18
100017 D 05-Apr-18
100018 D 08-Apr-18
100019 D 19-Apr-18
100020 D 23-Apr-18
100021 D 29-Apr-18
Edited by StevieB - 23 May 2018 at 4:07am
