Hi, is there any way to convert epoch time to DateTime in signoz value panel? If I am changing units from none to DateTime ISO, it is sowing the wrong data. If I add the DateTime function in the query, it is showing a value of 0.

Please share the query you are using.

SELECT *toStartOfInterval*(*toDateTime*(*intDiv*(timestamp_ms, 1000)), INTERVAL 60 SECOND) as ts, *toInt64*(value) as value FROM signoz_metrics.distributed_samples_v2 INNER JOIN (SELECT fingerprint FROM signoz_metrics.time_series_v2 WHERE metric_name = 'process_start_time_seconds' AND temporality IN ['Cumulative', 'Unspecified'] AND *JSONExtractString*(labels, 'job_name') = {{.service_name}}) as filtered_time_series USING fingerprint WHERE metric_name = 'process_start_time_seconds' AND timestamp_ms >= {{.start_timestamp_ms}} AND timestamp_ms < {{.end_timestamp_ms}} ORDER BY timestamp_ms desc LIMIT 1 HI @nitya-signoz, This is the query