Forum Discussion
Introduction 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 default limit of 500 being set, so I tried manually added a limit of 255000 to make sure all results are calculated but this still doesn't work. I tried expanding the date range back a year leading to present, but that didn't work.
I'm using to_long() for the conversions. I managed to get #13 by guess/checking, but I don't even see the correct value in the list of values I'm looking at. It's in the right range, however, so it makes me think I'm doing this mostly correct.
Not sure what else to include here without providing too many spoilers. Let me know what you need.
5 Replies
- AbdelrhamnaAttia
Bronze II
Hello,
You can use this query for both questions 13 and 15
you need to select the average speed field and elapsed time - steven
Silver II
sorry, I haven't saved any informations on that one. maybe I have some time end of the week for that one.
- Cyb3rM0nK3y
Bronze II
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
- KieranRowley
Community Manager
Also darkmacheken, rusio, CyberShark, lupolder, KelvinK, RobN, IotS2024, BeluczakDelmar, T3S0r0, m1zt3rIL, Cyb3rM0nK3y, Fastlime, prb, Antantant, Egg_Shen 👀
- KieranRowley
Community Manager
steven CyberSharpe I know you have both completed this one, any tips for mysterylie?