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

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.

But it’s good when i group by Date Histogram Only

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

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