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