I am working on integrating Streamsheets in our telemetry monitoring system.
So I have installed Streamsheets 2.3.0 Docker image on a Debian 10 VM and started publishish telemetry data to Streamsheets’ Mosquitto 2.0 MQTT broker, and created a Streamsheets app to capture the data stream and show telemetry as a table and as a line chart.
So far so good, but I could not arrange everything on the sheet the way I wanted. I have encountered several issues along the way. Any help is appreciated.
Is it possible to set cell format to display both date and time, showing not only hours and minutes, but seconds as well?
I found a time format (without the date part) showing hours, minutes and seconds, but no date + time format that shows seconds as well as hours and minutes.
As a side note, the date + time format is only available from the toolbar, and not from the “Format cell” menu item in the cell context menu (opened on right mouse button click).
Is it possible to set the “wrap” format on a cell? For example, I have a long text in a header cell, and I want that text to be automatically wrapped, so that the column is not excessively wide. I was unable to find this option.
The arrivalTime field from inbox metadata, when cell format is set to time, is in UTC. I found no way of converting it to the local time, other than manually adding a TIME(3, 0, 0) value (my TZ offset). This, however, is a crutch, since this approach does not
take daylight savings time transition into account automatically. Is there an official way to show arrivalTime as local time?
Please note that the time zone of my Streamsheets server is set correctly.
I would like to display my telemetry data as a line chart, with X axis marked with arrivalTime timestamps. It must be an oversight on my part, but I could not find a way to configure line chart like this.
I have tried arranging my data table both horizontally and vertically, but X axis is marked with consecutive numerals (1, 2, 3, …). The timestamp row (or column) can be used as a data sequence, giving me yet another line on the chart, which is not what I want at all.