Cannot format timestamp to datetime when grouping by 2 or more terms in Elasticsearch

Grafana Elasticsearch
1

Hi there,

I’m visualizing a field A within a certain time period using Grafana 9.3.2 with Elasticsearch 7.10+, so I will need to query group by firstly Date Histogram and then by Terms A, but i found timestamp cannot be formatted to datetime when i tried to do so.

image
image1927×796 53.9 KB

But it’s good when i group by Date Histogram Only
image
image1573×746 46.2 KB

And I didn’t find any other transform method that can parse timestamps, any idea on this? Thanks in advance.

2

I think you can try convert transformation time timestamp, then fill the format to date using YYYY-MM-DD.