I have a measurement with dynamic field names. So my measurement is called “deviceStatus” and my fields are “device1”, “device23” and so on. The device ids are not in ascending order, but can randomly appear and disappear.
I would like to do a simple query that gives me the number of devices for which the deviceStatus measurement is available within the time range.
I can do a query that basically combines last() and count() so I get the number if there is any field available. The problem is, if there is none, I get no result. I would need to have the result 0 instead.
Is it possible?