Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Grafana, how to transform time column from timestamp to date

Tags:

grafana

I am trying to use transformation "Convert field type" to strip time from timestamp, but it seems not to work as I expect. Any idea how to get rid of time? I need only date in order to group by day

enter image description here

like image 248
rsobies Avatar asked Oct 16 '25 04:10

rsobies


1 Answers

If you just want to have a single line per day, you can use GROUP BY time(1d) in your query.

To hide the time part inside of the label, define an Override:

enter image description here

like image 106
StefanR Avatar answered Oct 18 '25 10:10

StefanR



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!