Hi Guys, I want to be able to generate a report per tenancy that shows when an After Hours point was enabled over the past month and the duration it was enabled for.
So far I can get the timestamp of when the point was enabled (or disabled) but not the duraion. Using: “history:/[stationname]/AfterHours_Level_04_AfterHours|bql:select timestamp, value where value = true and timestamp in bqltime.lastmonth order by timestamp asc”
I am absolutely wracking my brains. I have gotten away with the monthly report emails and mobile device graphic using totalizers but I just cannot figure this out.
Id love for it to be reletavised if possible also (syntax would be amazing but I know a huge ask) Any help is greatly appreciated! Thanks
. I didn’t know about this one.