Forum Discussion
mysterylie
Bronze I
Bronze IIntroduction To Elastic: Ep.9 – ES|QL
I'm stuck on questions 13 and 15. My eval statement seems to be working, and I thought it was fairly straight-forward overall but the values returned are not being accepted. I noticed there was a def...
So, this one took me some time to work out as well, I'm not sure I can provide any tips without giving the answer.
The query I used for 13 was - This will then give you the logs sorted with the longest elasped_time first.
For 15 I used the query -
There may be cleaner ways of doing it or easier ways but that is how I managed to get the correct results.
Hope that helps
AbdelrhamnaAttia
Bronze II
Bronze IIHello,
You can use this query for both questions 13 and 15
you need to select the average speed field and elapsed time
