Time of day on y-axis; How to use insert data to use the display unit "Date & Time"?

Grafana InfluxDB
1

I’m trying to graph some data for events that happen daily at different times of the day. Sometimes the events are late and I need to show this.

I thought that it would be simple to graph the data using the Left Y Unit “Date & TIme”, ( YYYY-MM-DD HH:mm:ss ).

So how should I insert the data into my influx back end?

Here’s three attempts:

1.
curl -i -XPOST 'http://localhost:8086/write?db=mydb' --data-binary 'timeoffset,host=server02 value=0.67,offset=1512942162'

It seems to works but the date is “1970-01-18 09:40:00” for some reason.

2.
curl -i -XPOST 'http://localhost:8086/write?db=mydb' --data-binary 'timeoffset,host=server02 value=0.67,offset=1512940886073851433'

“Invalid date” appears in the Y-axis.

3.
curl -i -XPOST 'http://localhost:8086/write?db=mydb' --data-binary 'timeoffsets,host=server02 value=0.67,offset="2017-12-10 21:21:26"'

Again everything is in 1970.

What format should the time be inserted into influx in order for the Date & Time display unit to work properly?

Appreciate any advice!

Mick

2

Also tried specifying an integer:

curl -i -XPOST 'http://localhost:8086/write?db=testDB' --data-binary 'timeoffsetses,host=server02 value=0.67,offset=1512940886073851433i'

Invalid date.

Just to clarify with a picture:

2017-12-11 11_47_44-Grafana
2017-12-11 11_47_44-Grafana372×585 12.2 KB

What format should the time be inserted into influx in order for the Date & Time display unit to work properly?

Epoch time? A date string? Neither seems to work.

Thanks.

3

It was Epoch microseconds as integer if anyone else is wondering.

curl -i -XPOST 'http://localhost:8086/write?db=testDB' --data-binary 'timeoffsetses,host=server02 value=0.67,offset=1512989705000i'

It’s still not ideal. There’s no way to graph time of day on the y-axis in Grafana. Seems like it should be a simple feature. It’s almost there with the Date & Time.