I have some building occupancy data generated from our wireless network that is logged as one record per floor of each building every 5 minutes. I'm now trying to export a spreadsheet to another user who has requested a 15 minute resolution of this data. I believe I'm looking for a WHERE clause where the minutes of _time for the event fall within a set of ranges. The data isn't aligned to the clock very well so the first record could be in minute 0 to minute 5, so second would need to be 10-15, etc. But my skill level with using these functions is falling short here. 🙂 ... View more

I can make either the IOS app or the Security Suite work but not both together. I believe it is related to both apps defining an IOS event but in different ways. However I am quite new to this and a little guidance would be greatly appreciated. ... View more