First time posting and relatively new to the influxdata applications. First off great set these guys have produced, absolutely loving the ease so far of getting what I need out of them.
I have got some data going into influxdb via the mqtt plugin of telegraf. No issues with any of that. The payload of my mqtt topic is formatted in influx line protocol and has the timestamp on the end in unix down to the ns. The timestamp of the event is quite crucial for my application so this is why the timestamp is in there, I do not want the data in influxdb to be timestamped with the time it is written into the database.
The issue I am experiencing is within chronograf. If I have a query using “WHERE time > :dashboardTime:” it will always return no results. If I then stop sending messages containing a timestamp I can get the dashboards in chronograf to work as desired. Put the timestamp back in and it all falls apart.
I do not want to hardcode a time > now() - 1 day into the query as I want the user to be able to do this via the relative time picker at the top of the graphs.
Has anybody experienced this issue or know how to get around it?