I have an index with some documents that are like:
The service was completed in 2.5 seconds
The service was completed in 1.7 seconds
The service was completed in 3.2 seconds
I want to build a view that will show the average service time, so I have to extract the numeric values from each field and do the average.
I can't use a scripted field.
Yes, I know I can do this at ingestion time, but I can't at this moment.
I have tried to use the "JSON input" field, but with no luck.