Thanks for the reply, I have looked through both threads but not found the answer.
I can make “Group by” work if I only use it on a “sensor”, but must also have shown the other information “GW”, “Battery” etc.
Is the database incorrectly built? (which I can see many others are advised to look at)
I want approx. 500 sensor that reports data where sensor = name of the device. They sign up for the bubble through the API. with information on battery status, signal strength, etc.