Forum Discussion

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

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 ALL trips that start in the borough of “Brooklyn” and end in the borough of “Manhattan”? Provide your answer to at least three decimal places. 
any ideas?

cyber crisis simulations
cyber range exercises
cyber ranges
cyber team simulations
cyberpro
defensive cyber
help & support
immersive labs
immersive labs application security
offensive cyber

1 Reply

  • netcat's avatar
    netcat
    Icon for Silver III rankSilver III
    2 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