Making a delay scripted field from a field containing several dates

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.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.