I am trying to make a table with a batch number, the beginning of the batch and the end of the batch. I have it formatted at a table and visualized as such. My query is:
MIN(Time_Stamp) AS’ Batch_Start’,
MAX(Time_Stamp) AS ‘Batch_End’
My problem is that Batch_Start and Batch_End are showing like ‘0
2020-12-11T09:47:31Z’ instead of ‘2020-12-11 09:47:31’.
This problem is resolved when I us AS ‘time’, but I’d like my columns to have more descriptive names. Is it possible to make grafana display timestamp values as such even if they’re not called ‘time’?
My data source is MySQL and I’m using Grafana v7.2.1 in Windows