How to transform Unix Timestamp to Date in Grafana Table Panel

Hello,

I’m currently working on a dashboard in Grafana and I’ve encountered an issue that I need help with. In one of my Table panels, I have a column that contains Unix timestamps, for example, 1687846075.

What I would like to do is to display these Unix timestamps in a more human-readable date/time format, such as “27/06/2023 08:07:55”, directly within the table.

So far, I have attempted to use the “Transform” tab in Grafana to convert these Unix timestamps into a date/time format, but I haven’t had any success. Despite trying various options and searching through the available documentation, I haven’t been able to find a way to perform this transformation directly within Grafana’s interface.

Could anyone guide me on how to achieve this? I’m currently using Opensearch as my data source.

Any help or suggestions would be greatly appreciated!

Thank you in advance.

Has Grafana resolved the problem with transforming Unix timestamps to a Date field? I’m having this same issue in my dashboard.

Use proper unit for that unix timestamp column.

what is your datasource