[Discover][ES|QL] Brushing a timeseries should keep the preferred chart configuration

[stratoula]

Describe the feature:

In Discover we are computing the interval based on the timepicker. And we rename the column with this intgerval in the name. Although this PR improves the experience a lot #197453 it doesnt solve it for the brushing. The reason is because different interval means different column name which means that the suggestions will re run.

We could fix it with 2 ways?

• flag the brushing and when this happens send the preferredChart type and attributes in the suggestions api. Not sure how easy is to understand that the change of the query was caused from brushing
• Change the attributes of the histogram to give the name in the x axis instead of the column. So the esql query will always have the same column name but the vis attributes will change depending on the interval.

[elasticmachine]

Pinging @elastic/kibana-data-discovery (Team:DataDiscovery)

[elasticmachine]

Pinging @elastic/kibana-esql (Team:ESQL)

[jughosta]

Any changes in the time range filter can result in a different time interval for ES|QL histogram. So it's not only when brushing but also for manual updates.

kibana/src/plugins/unified_histogram/public/services/lens_vis_service.ts

Line 573 in f962cdc

`| EVAL timestamp=DATE_TRUNC(${queryInterval}, ${dataView.timeFieldName}) | stats results = count(*) by timestamp${breakdown}${sortBy} | rename timestamp as \`${dataView.timeFieldName} every ${queryInterval}\``

Change the attributes of the histogram to give the name in the x axis instead of the column. So the esql query will always have the same column name but the vis attributes will change depending on the interval.

I think this solution would be the best.