Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
reynold522
Helper II
Helper II

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

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 Currenttimestamp
11219.01.2023
21219.01.2023
32219.01.2023
4  19.01.2023
5  19.01.2023
11220.01.2023
22220.01.2023
31220.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

 

 

 

 

 

2 ACCEPTED SOLUTIONS

sorry for confusion.

 

number of rows with voltage <2V

View solution in original post

@reynold522  

Mahesh0016_1-1674218406391.png

 


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

 

View solution in original post

5 REPLIES 5
Mahesh0016
Super User
Super User

@reynold522please share sample output in table format?

@Mahesh0016 

thank you for your question

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

Thanks in advance!

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

sorry for confusion.

 

number of rows with voltage <2V

@reynold522  

Mahesh0016_1-1674218406391.png

 


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

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.