Graph input order

Dashboard
1

I currently have a system in which 7 sensors write to a database at the same time. I have a graph reading from this database 7 entries at a time.

Does anyone know how to make sure that I don't miss entries, and also how to make sure it reads the sensors in order (1, 2, 3, 4, 5, 6, 7)?

2

At what part of the operation do you mean make sure you don't miss any, and when you say you want it to read them in order do you mean read from the database, or what?

3

Currently the flow reads the 7th latest entries from the database. This means if it updates while the entries are being written it only reads part of what I need it to.

Also in terms of 'read them in order' I mean within the graph. The legend may read "1, 3, 4, 2, 5, 7, 6" when I want it to be in numerical order.

4

What query are you using to get them from the database?