cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
datastrategy Frequent Visitor
Frequent Visitor

Count Events that are consecutively over a certain total time

I would like to know "how many visits to a location are over say 3 minutes" because that will say the person is definently there... I have a large table to sensors that tell where a person is, but need to count the total time for each location and then if( function and count function to see how many times a day a person is say "in the bathroom."

 

here's the PBIX file...

https://1drv.ms/u/s!Al_7ttRtqlRUg7h0hSQbBI1YSXZVCw?e=Gl5dYB

 

I can count if each sensor lasts longer than 3 minutes, but want to count if the consecutive events are larger than 3 or 5 minutes.

 

the hallway here would be the sum of the total duration for that time.  Maybe the date axis is then the min time for each segment of locations?

Annotation 2019-07-16 154522.jpg

2 ACCEPTED SOLUTIONS

Accepted Solutions
datastrategy Frequent Visitor
Frequent Visitor

Re: Count Events that are consecutively over a certain total time

so hallway below would be counted as 4 times this day in this picture.  (I'm binning by 15 min increments, so might have missed others that are within the 15 min segments, just using this for explanactino purposes)

 

Annotation 2019-07-16 160208.jpg

Community Support Team
Community Support Team

Re: Count Events that are consecutively over a certain total time

@datastrategy 

 

You may take a look at the following post.

https://community.powerbi.com/t5/Desktop/How-to-create-ID-variable-by-value-an-other-variable/m-p/36...

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
datastrategy Frequent Visitor
Frequent Visitor

Re: Count Events that are consecutively over a certain total time

so hallway below would be counted as 4 times this day in this picture.  (I'm binning by 15 min increments, so might have missed others that are within the 15 min segments, just using this for explanactino purposes)

 

Annotation 2019-07-16 160208.jpg

Community Support Team
Community Support Team

Re: Count Events that are consecutively over a certain total time

@datastrategy 

 

You may take a look at the following post.

https://community.powerbi.com/t5/Desktop/How-to-create-ID-variable-by-value-an-other-variable/m-p/36...

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 321 members 3,195 guests
Please welcome our newest community members: