Problem

Lens with ES|QL does not support multidimensional breakdown in queries and because of that we are generating an ugly query. And this generates multiple concerns:

• It shows that ES|QL still is limited
• Users can save those queries in their dashboards, persisting a query that is far from ideal

Acceptance criteria

• The query does not contain anything hacky to support multi-dimensions because now we won't have it
  • If the user selects 0 dimensions: TS metrics-index | STATS AVG(metric_name) BY BUCKET(@timestamp, 100, ?_tstart, ?_tend)
  • If the user selects 1 dimensions: TS metrics-index | STATS AVG(metric_name) BY BUCKET(@timestamp, 100, ?_tstart, ?_tend), dimension
  • No possibility to select more than 1 dimensions
• User can only select one dimension in the dimensions dropdown similar to what would happen in the breakdown in logs

  • Option 1: Re-use the same component that we have in Logs

    • 
    • 
    • Filter by value remains like now:
      

  • Option 2: Any other suggestion from your side?