Calculating the agging between record

[Anonymous]

Hi all,

I

 would like to be able to calculate the agging of the status of a ticket based on refence date that i'm using.

The tichek besides it's Id, it has a status and it has a date of that status (basically I'm taking photos from my ticketing system to do analysis

Ref Date	Ticket Id	Status
15-10-2018	Ticket_1	Open
30-10-2018	Ticket_1	Open
15-11-2018	Ticket_1	In Analysis
15-10-2018	Ticket_2	Open
30-10-2018	Ticket_2	Open
15-11-2018	Ticket_2	Open
30-10-2018	Ticket_3	Close
15-11-2018	Ticket_3	Close
15-11-2018	Ticket_4	Open

When calculationg selecting in the dashboard the Info_Lnk_date (filter) the agging  results I wan't to get are (by Inf_lnk_date):

Info_Lnk_Date		Agging	Observations
15-10-2018	Ticket_1	0
15-10-2018	Ticket_2	0
15-10-2018	Ticket_3		should not appear
15-10-2018	Ticket_4		should not appear
30-10-2018	Ticket_1	15	because the status has not changed
30-10-2018	Ticket_2	15	because the status has not changed
30-10-2018	Ticket_3	0
30-10-2018	Ticket_4		should not appear
15-11-2018	Ticket_1	0	There was a change in the status
15-11-2018	Ticket_2	30
15-11-2018	Ticket_3	15
15-11-2018	Ticket_4	0

[sunny_talwar]

Are you looking to create the Aging field in the script?

[Anonymous]

Yes, that could be a solution ...