Problem with epoch timestamps to human readable date conversion

Grafana version : 4.6.0
Datasource : Zabbix (Plugin from https://github.com/alexanderzobnin/grafana-zabbix)
OS : Ubuntu 14.04

Hello! I’m still in the process of learning how to handle grafana properly and I’m at the point I need some help.

I’m pulling from Zabbix an epoch timestamp in seconds, which is easier to handle with triggers than string dates, in a Singlestat panel.

The problem is that I need grafana to show a human readable date, whatever the format is (need year, month, day, hour, minute and second).
I couldn’t do anything useful with “options/unit” because it gaves me a date from 1970.

I tried to find equivalent issues but found nothing close to this, or closed issued without useful informations. I tried to configure Zabbix so it knows it’s a “unixtime” unit but always returns it in an epoch timestamp format in Grafana. I also tried to look if I could work something with the functions in query mode but found nothing.

Am I missing something that could do the job? Should I open an issue to ask for a feature that could handle epoch timestmap in pretty format?

I couldn’t put the third screenshot of the Metrics tab because I’m new here, but here it is.

Hello,
I have the same problem.
Managed to solve?

Hi,

I found a workaround on a forum. I used a scale x1000 function on the metric and it worked using a time and date unit.

3 Likes

Worked for me either, thanks!

It works on v6.1.0

I have to say that it’s a weird feature.

Thanks!