[ES|QL] Field statistics panel erroring out on relative time range(?) and displays blank loading panel

[bhavyarm]

Kibana version: 8.15.0 BC1

Browser version: chrome latest

Browser OS version: OS X

Original install method (e.g. download page, yum, from source, etc.): from staging

Describe the bug: If user has set their relative time range - as from time to 10 days ago and to time to 2 hours ago on dashboard, then adding field statistics panel is erroring out with "Error getting total count for ES|QL data: {"params":{"query":"from kibana_sample_data_logs | limit 10\n | STATS count = COUNT(*) | LIMIT 1","filter":{"bool":{"must":[],"filter":[{"range":{"@timestamp":{"format":"strict_date_optional_time","gte":"2024-06-29 20:39:02","lte":"2024-07-09 10:40:14"}}}],"should":[],"must_not":[]}}}}"

Steps to reproduce:

1. Install sample data logs, create a dashboard and set the time range to relative from time to 10 days ago and to time to 2 hours ago
2. Click on add panel and try to add field statistics panel
3. The action errors out with "Error getting total count for ES|QL data: {"params":{"query":"from kibana_sample_data_logs | limit 10\n | STATS count = COUNT(*) | LIMIT 1","filter":{"bool":{"must":[],"filter":[{"range":{"@timestamp":{"format":"strict_date_optional_time","gte":"2024-06-29 20:39:02","lte":"2024-07-09 10:40:14"}}}],"should":[],"must_not":[]}}}}"

Screenshots (if relevant):

Error fetching field statistics for ES|QL query: fetchOverallStats Error: Failed to parse with all enclosed parsers
    at g (kbn-ui-shared-deps-src.js:43:305479)
    at search_interceptor_SearchInterceptor.handleSearchError (data.plugin.js:1:390778)
    at data.plugin.js:1:394787
    at kbn-ui-shared-deps-npm.dll.js:377:1521539
    at s._error (kbn-ui-shared-deps-npm.dll.js:6:45730)
    at t.error (kbn-ui-shared-deps-npm.dll.js:361:29551)
    at kbn-ui-shared-deps-npm.dll.js:351:61135
    at i (kbn-ui-shared-deps-npm.dll.js:361:245075)
    at t.error (kbn-ui-shared-deps-npm.dll.js:351:61002)
    at Object.error (kbn-ui-shared-deps-npm.dll.js:361:890160)
Pt @ core.entry.js:16
console.error @ core.entry.js:16
(anonymous) @ dataVisualizer.chunk.8.js:3
await in (anonymous) (async)
(anonymous) @ dataVisualizer.chunk.8.js:3
$c @ kbn-ui-shared-deps-npm.dll.js:425
t.unstable_runWithPriority @ kbn-ui-shared-deps-npm.dll.js:433
Xo @ kbn-ui-shared-deps-npm.dll.js:425
Uc @ kbn-ui-shared-deps-npm.dll.js:425
wc @ kbn-ui-shared-deps-npm.dll.js:425
(anonymous) @ kbn-ui-shared-deps-npm.dll.js:425
t.unstable_runWithPriority @ kbn-ui-shared-deps-npm.dll.js:433
Xo @ kbn-ui-shared-deps-npm.dll.js:425
Qo @ kbn-ui-shared-deps-npm.dll.js:425
Zo @ kbn-ui-shared-deps-npm.dll.js:425
zc @ kbn-ui-shared-deps-npm.dll.js:425
La @ kbn-ui-shared-deps-npm.dll.js:425
(anonymous) @ presentationPanel.plugin.js:1
Promise.then (async)
(anonymous) @ presentationPanel.plugin.js:1
(anonymous) @ presentationPanel.plugin.js:1
$c @ kbn-ui-shared-deps-npm.dll.js:425
t.unstable_runWithPriority @ kbn-ui-shared-deps-npm.dll.js:433
Xo @ kbn-ui-shared-deps-npm.dll.js:425
Uc @ kbn-ui-shared-deps-npm.dll.js:425
wc @ kbn-ui-shared-deps-npm.dll.js:425
(anonymous) @ kbn-ui-shared-deps-npm.dll.js:425
t.unstable_runWithPriority @ kbn-ui-shared-deps-npm.dll.js:433
Xo @ kbn-ui-shared-deps-npm.dll.js:425
Qo @ kbn-ui-shared-deps-npm.dll.js:425
Zo @ kbn-ui-shared-deps-npm.dll.js:425
zc @ kbn-ui-shared-deps-npm.dll.js:425
La @ kbn-ui-shared-deps-npm.dll.js:425
onResize @ dashboard.chunk.7.js:1
(anonymous) @ dashboard.chunk.7.js:1
(anonymous) @ dashboard.chunk.7.js:1
j @ dashboard.chunk.7.js:1
P @ dashboard.chunk.7.js:1
t @ dashboard.chunk.7.js:1
requestAnimationFrame (async)
(anonymous) @ dashboard.chunk.7.js:1
(anonymous) @ dashboard.chunk.7.js:1
(anonymous) @ dashboard.chunk.7.js:1
characterData (async)
o @ dashboard.chunk.7.js:1
R @ dashboard.chunk.7.js:1
e.run @ dashboard.chunk.7.js:1
e.schedule @ dashboard.chunk.7.js:1
e.observe @ dashboard.chunk.7.js:1
e.observe @ dashboard.chunk.7.js:1
(anonymous) @ dashboard.chunk.7.js:1
(anonymous) @ dashboard.chunk.7.js:1
(anonymous) @ dashboard.chunk.7.js:1
Fc @ kbn-ui-shared-deps-npm.dll.js:425
t.unstable_runWithPriority @ kbn-ui-shared-deps-npm.dll.js:433
Xo @ kbn-ui-shared-deps-npm.dll.js:425
Bc @ kbn-ui-shared-deps-npm.dll.js:425
wc @ kbn-ui-shared-deps-npm.dll.js:425
zc @ kbn-ui-shared-deps-npm.dll.js:425
fl @ kbn-ui-shared-deps-npm.dll.js:425
(anonymous) @ kbn-ui-shared-deps-npm.dll.js:425
Cc @ kbn-ui-shared-deps-npm.dll.js:425
Ml @ kbn-ui-shared-deps-npm.dll.js:425
t.render @ kbn-ui-shared-deps-npm.dll.js:425
render @ dashboard.chunk.7.js:1
(anonymous) @ dashboard.plugin.js:1
await in (anonymous) (async)
(anonymous) @ dashboard.plugin.js:1
$c @ kbn-ui-shared-deps-npm.dll.js:425
t.unstable_runWithPriority @ kbn-ui-shared-deps-npm.dll.js:433
Xo @ kbn-ui-shared-deps-npm.dll.js:425
Uc @ kbn-ui-shared-deps-npm.dll.js:425
wc @ kbn-ui-shared-deps-npm.dll.js:425
(anonymous) @ kbn-ui-shared-deps-npm.dll.js:425
t.unstable_runWithPriority @ kbn-ui-shared-deps-npm.dll.js:433
Xo @ kbn-ui-shared-deps-npm.dll.js:425
Qo @ kbn-ui-shared-deps-npm.dll.js:425
Zo @ kbn-ui-shared-deps-npm.dll.js:425
Cc @ kbn-ui-shared-deps-npm.dll.js:425
Ml @ kbn-ui-shared-deps-npm.dll.js:425
t.render @ kbn-ui-shared-deps-npm.dll.js:425
H @ dashboard.chunk.2.js:1
mount @ dashboard.plugin.js:1
await in mount (async)
(anonymous) @ core.entry.js:16
(anonymous) @ core.entry.js:16
(anonymous) @ core.entry.js:16
As @ kbn-ui-shared-deps-npm.dll.js:425
Fc @ kbn-ui-shared-deps-npm.dll.js:425
t.unstable_runWithPriority @ kbn-ui-shared-deps-npm.dll.js:433
Xo @ kbn-ui-shared-deps-npm.dll.js:425
Bc @ kbn-ui-shared-deps-npm.dll.js:425
wc @ kbn-ui-shared-deps-npm.dll.js:425
(anonymous) @ kbn-ui-shared-deps-npm.dll.js:425
t.unstable_runWithPriority @ kbn-ui-shared-deps-npm.dll.js:433
Xo @ kbn-ui-shared-deps-npm.dll.js:425
Qo @ kbn-ui-shared-deps-npm.dll.js:425
Zo @ kbn-ui-shared-deps-npm.dll.js:425
zc @ kbn-ui-shared-deps-npm.dll.js:425
enqueueSetState @ kbn-ui-shared-deps-npm.dll.js:425
m.setState @ kbn-ui-shared-deps-npm.dll.js:401
(anonymous) @ kbn-ui-shared-deps-npm.dll.js:351
r @ kbn-ui-shared-deps-npm.dll.js:356
(anonymous) @ kbn-ui-shared-deps-npm.dll.js:356
notifyListeners @ kbn-ui-shared-deps-npm.dll.js:356
C @ kbn-ui-shared-deps-npm.dll.js:356
(anonymous) @ kbn-ui-shared-deps-npm.dll.js:356
confirmTransitionTo @ kbn-ui-shared-deps-npm.dll.js:356
push @ kbn-ui-shared-deps-npm.dll.js:356
navigate @ core.entry.js:16
d @ core.entry.js:16
await in d (async)
navigateToUrl @ core.entry.js:16
onClick @ core.entry.js:16
onClick @ core.entry.js:16
He @ kbn-ui-shared-deps-npm.dll.js:425
Xe @ kbn-ui-shared-deps-npm.dll.js:425
(anonymous) @ kbn-ui-shared-deps-npm.dll.js:425
Cr @ kbn-ui-shared-deps-npm.dll.js:425
Tr @ kbn-ui-shared-deps-npm.dll.js:425
(anonymous) @ kbn-ui-shared-deps-npm.dll.js:425
De @ kbn-ui-shared-deps-npm.dll.js:425
(anonymous) @ kbn-ui-shared-deps-npm.dll.js:425
Dr @ kbn-ui-shared-deps-npm.dll.js:425
en @ kbn-ui-shared-deps-npm.dll.js:425
Jt @ kbn-ui-shared-deps-npm.dll.js:425
t.unstable_runWithPriority @ kbn-ui-shared-deps-npm.dll.js:433
Xo @ kbn-ui-shared-deps-npm.dll.js:425
ke @ kbn-ui-shared-deps-npm.dll.js:425
Zt @ kbn-ui-shared-deps-npm.dll.js:425Understand this error

[elasticmachine]

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

[elasticmachine]

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

[stratoula]

@qn895 can you take a look? I can't replicate it.

[bhavyarm]

Zoomed with @qn895 now. Reproduced it couple of times and then couldn't reproduce it anymore after logging out, clearing application cache and logging back in. Not sure whats the funkly timepicker is doing. Cheers!

[bhavyarm]

@qn895 another bug where I for sure know how to reproduce that error ^ ;) https://github.com/elastic/kibana/issues/188149

[qn895]

Closing since it hasn't been reproduced yet