Hello, i would like to make a scripted field of a delay process time from a field which contains several dates separated by a comma like this
dates_multi : 2020-07-17 04:02:00,2020-07-24 04:02:00,2020-07-31 04:02:00,2020-08-07 04:02:00,2020-08-14 04:02:00,2020-08-21 04:02:00,2020-08-28 04:02:00,2020-09-04 04:02:00,2020-11-02 01:36:37
So first of all i would try to split the field by comma then taking the last element of the list minus the first element of the splited list then returning my scripted field in a day format like this, ex: delay_process: 3.5
however I am not able to figure out how to do this processing using painless, I would be grateful for any kind of help.