Forum Discussion

M_Waters-221's avatar
M_Waters-221
Icon for Bronze I rankBronze I
6 months ago
Solved

Introduction to Elastic: Ep.9 - ES|QL

I’m stuck on question 18 i need this to complete the lab. The question says ‘Perform a final query using all of the techniques used in the previous questions. What is the average speed per hour for A...
cyber crisis simulations
cyber range exercises
cyber ranges
cyber team simulations
cyberpro
defensive cyber
help & support
immersive labs
immersive labs application security
offensive cyber
  • netcat's avatar
    netcat
    6 months ago

    You filter for the relevant trips, but don't create an overall sum, but use the formula used in a question before to calculate the average speed per trip. Then do a sum of these and divide it by the number of results. You can count the number of results manually, or with STATS.
    https://www.elastic.co/docs/reference/query-languages/esql/commands/processing-commands#esql-stats-by

netcat's avatar
netcat
Icon for Silver III rankSilver III
6 months ago

You filter for the relevant trips, but don't create an overall sum, but use the formula used in a question before to calculate the average speed per trip. Then do a sum of these and divide it by the number of results. You can count the number of results manually, or with STATS.
https://www.elastic.co/docs/reference/query-languages/esql/commands/processing-commands#esql-stats-by