Hi everyone, I am trying to figure out how to adapt the system to my needs.
I have telemetry coming to topics such as events/<source_id>
, e.g., events/device_1
, events/device_2
, and so on.
I would like my spreadsheet to show me several things:
- the time of the last message that came from each source, e.g.
device_1
- I want this cell to turn red if the last message is more than N minutes old
Because I have many sources of info (circa 400 devices), I want them to be created dynamically. The algorithm I envision might be like this:
- Split topic by "/" and extract the last element
- Go to the row that corresponds to this device
- Set the second column of that row to the timestamp (and apply color rules accordingly)
I’ve tinkered with Streamsheets and I found if very flexible, the concept is amazing! However, I haven’t figured out how I can adapt it to my needs, thus I ask for help.
Note: because the number of devices in my system is pretty much a constant, I would be OK with a one-time effort of creating some sort of a map, like device_1 -> row 1
, device_2 -> row2
, etc. I look forward to your hints.