topic Re: Count IoT devices without data and used this information as filter. in DAX Commands and Tips

Count IoT devices without data and used this information as filter.

reynold522 — Fri, 20 Jan 2023 10:34:18 GMT

Hi all,

We have a lot of IoT devices installed.

Some will not send data to cloud due to contact problem/configuration problem.

IoT ID	Voltage	Current	timestamp
1	1	2	19.01.2023
2	1	2	19.01.2023
3	2	2	19.01.2023
4			19.01.2023
5			19.01.2023
1	1	2	20.01.2023
2	2	2	20.01.2023
3	1	2	20.01.2023
4			20.01.2023
5			20.01.2023

I would like to have
1. a list of ID (in this case ID 4 and 5) of those IoT devices and count number of IoT devices which is not sending data to cloud

2. exclude those ID numbers in calculation to have better efficiency.

if I do intergral of battery current, I can exclude ID 4 and 5 to save computing data and time.

Thanks in advance!

Best regards

Re: Count IoT devices without data and used this information as filter.

Mahesh0016 — Fri, 20 Jan 2023 12:19:52 GMT

reynold522please share sample output in table format?

Re: Count IoT devices without data and used this information as filter.

reynold522 — Fri, 20 Jan 2023 12:23:54 GMT

Mahesh0016

thank you for your question

e.g., count number of points with voltage<2 from each IoT ID.

Thanks in advance!

Re: Count IoT devices without data and used this information as filter.

Mahesh0016 — Fri, 20 Jan 2023 12:27:22 GMT

reynold522 please can you explain what is point in sample data.

Re: Count IoT devices without data and used this information as filter.

reynold522 — Fri, 20 Jan 2023 12:29:01 GMT

sorry for confusion.

number of rows with voltage <2V

Re: Count IoT devices without data and used this information as filter.

Mahesh0016 — Fri, 20 Jan 2023 12:40:15 GMT

reynold522

reynold522 if it is not correct so please share table formate output so we can understand your requirment of output.