Hi - new to Grafana, so apologies if I missed something in the documentation.
I’m trying to put together a super simple dashboard based on a (regularly updated) Google Sheet. I’m using the Google Sheets plugin to connect to my sheet as a data source, and that’s working smoothly. Grafana can show the data as a table in a panel.
My sheet has data structured like this:
|Timestamp|Humidity (%rH)|
|1596084542|44|
|1596084607|44|
|1596084666|44|
|1596084726|44|
|1596084786|44|
|1596084846|44|
|1596084906|44|
…
Challenge is, the panel always reports ‘Unable to graph data’ whenever I try to display it as a time series chart.
I’ve set up a transform - a binary operation that multiplies the timestamp by 1000, then adds it as a new column, which is formatted as a datetime. This works, it translates the timestamp perfectly to the time it represents. So Grafana can clearly read the timestamps, but isn’t using it to set up a time series chart.
Any suggestions would be helpful, or anything I can post screenshots of or configurations for. Thanks for any tips.