So I have this database that will have millions of entries. For each wind turbine(there will be many), there will be an entry about every couple of seconds. Each entry is timestamped.
I need to create a report that will count the number of hours that a event happens. For example, there could be a status field that will normally be 'on' but when something happens it will switch to 'off' . What I want to do is be able to count the hours that it was operating normally. Then, I'd like to count the hours that it was 'off' or 'being serviced'
How do I go about this? Any guidance would be appreciated.