Remove Hours minutes and seconds from a table

Hi, i have AWS CloudWatch as Datasource.
Im trying to make a dashboard with some date data.
My query returns this info:

data

I just want to remove the hour + min + secs time stamps, i only need the YYYY-MM-DD

Im using Grafana 8.0.6

Thanks in advance

1 Like

I’m also having this same problem.
Presume you’re using API Get and the result is JSON?
I’ll let you know I get anywhere!

Hello, maybe it’s too late but I have the answer.

This is my input before all transformation :

grafana1

But I don’t want this format, so, I go “Transform”, then “Convert field type”

The result is :
grafana3

But now, I want to erase the “000” like your problem.

So now I go on right panel and click on “Add Field Override”

grafana4

And I manually add this : time: YYYY-MM-DD hh:mm:ss (copy paste)
(time: YYYY-MM-DD in your case)

So now I have this result :
grafana5

So now I have the good format and I delete the “000”

See you.

This topic was automatically closed after 365 days. New replies are no longer allowed.