Build a history table

I use a ticketing system and would like to calculate the running number of days that a ticket is ‘open’. I think I might use the DATASET_DELIVERY_DATE to build a ‘history’ table? If I run my import...