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/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.
- 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.