Hi,
Hope someone can help.
I have a table of three columns (please see below).
The first is a list of Work Order Numbers.
The second is a list of Asset Numbers that the Work Orders are assigned to.
The third is 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
[TABLE="border: 0, cellpadding: 0, cellspacing: 0, width: 241"]
Work Order
[/td][td]Asset
[/td][td]Report Date
[/td][/tr][tr][td]100001
[/td][td]A
[/td][td]01-Apr-18
[/td][/tr][tr][td]100002
[/td][td]A
[/td][td]04-Apr-18
[/td][/tr][tr][td]100003
[/td][td]A
[/td][td]10-Apr-18
[/td][/tr][tr][td]100004
[/td][td]A
[/td][td]20-Apr-18
[/td][/tr][tr][td]100005
[/td][td]B
[/td][td]02-Apr-18
[/td][/tr][tr][td]100006
[/td][td]B
[/td][td]10-Apr-18
[/td][/tr][tr][td]100007
[/td][td]B
[/td][td]16-Apr-18
[/td][/tr][tr][td]100008
[/td][td]B
[/td][td]20-Apr-18
[/td][/tr][tr][td]100009
[/td][td]B
[/td][td]25-Apr-18
[/td][/tr][tr][td]100010
[/td][td]B
[/td][td]30-Apr-18
[/td][/tr][tr][td]100011
[/td][td]C
[/td][td]01-Apr-18
[/td][/tr][tr][td]100012
[/td][td]C
[/td][td]05-Apr-18
[/td][/tr][tr][td]100013
[/td][td]C
[/td][td]15-Apr-18
[/td][/tr][tr][td]100014
[/td][td]C
[/td][td]22-Apr-18
[/td][/tr][tr][td]100015
[/td][td]C
[/td][td]28-Apr-18
[/td][/tr][tr][td]100016
[/td][td]C
[/td][td]29-Apr-18
[/td][/tr][tr][td]100017
[/td][td]D
[/td][td]05-Apr-18
[/td][/tr][tr][td]100018
[/td][td]D
[/td][td]08-Apr-18
[/td][/tr][tr][td]100019
[/td][td]D
[/td][td]19-Apr-18
[/td][/tr][tr][td]100020
[/td][td]D
[/td][td]23-Apr-18
[/td][/tr][tr][td]100021
[/td][td]D
[/td][td]29-Apr-18
[/td][/tr]
[/TABLE]