Bird
Raised Fist0

You want to create a Lens visualization showing average response time per user, but only for users with more than 10 requests. How can you achieve this using Lens drag-and-drop features?

hard🚀 Application Q15 of Q15
Elasticsearch - Kibana and Visualization

You want to create a Lens visualization showing average response time per user, but only for users with more than 10 requests. How can you achieve this using Lens drag-and-drop features?

AUse Lens to write a custom query filtering users with more than 10 requests, then drag fields normally
BDrag 'user.keyword' to 'X-axis', 'requests' to 'Y-axis' with 'Sum' aggregation, then filter 'response_time < 10'
CDrag 'response_time' to 'Break down by', 'user.keyword' to 'Y-axis' with 'Count' aggregation, no filters needed
DDrag 'user.keyword' to 'Break down by', 'response_time' to 'Y-axis' with 'Average' aggregation, then add a filter 'requests > 10' to the visualization
Step-by-Step Solution
Solution:
  1. Step 1: Set up breakdown and metric

    Drag 'user.keyword' to 'Break down by' to split by user, and 'response_time' to 'Y-axis' with 'Average' aggregation to get average response time.
  2. Step 2: Apply filter for requests count

    Add a filter 'requests > 10' to include only users with more than 10 requests.
  3. Final Answer:

    Drag 'user.keyword' to 'Break down by', 'response_time' to 'Y-axis' with 'Average' aggregation, then add a filter 'requests > 10' to the visualization -> Option D
  4. Quick Check:

    Breakdown + average metric + filter = correct Lens setup [OK]
Quick Trick: Use filters plus breakdown and aggregation to refine Lens charts [OK]
Common Mistakes:
MISTAKES
  • Filtering wrong field or with wrong condition
  • Mixing up X-axis and Break down by roles
  • Trying to write queries instead of using filters

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More Elasticsearch Quizzes