Forum Discussion
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?
- Anonymous7 years ago
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)
Anonymous
You may take a look at the following post.
2 Replies
- AnonymousNot applicable
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)
- v-chuncz-msft
Community Support
Anonymous
You may take a look at the following post.