Wondering if someone can help with the following issue or propose a workaround:
I have a number of MQTT devices and I track if they are online or not (0=offline 1=online)
However, “flapping” occurs once in a while, IE : it rapidly swap offline/online within the same second, therefore both 0 and 1 appear under the same second even if technically 0/offline came before 1/online.
This can be seen correctly under a “table” viz.
However, when trying to track in a visual way (with time series or “discrete” for instance)
it seems to only retain 0 (which I assume is the “first” value under that second).
In reality, we should see 1/online everywhere, except for that split second 0/offline.
But instead, it just “sticks” at 0/offline.
Any workaround for this? open to any ideas so I can correctly reflect reality in the graphs.