Would be cool if the aggregate table services would already contain interesting dimensions:
- Title (Title_First, Title_Last, Title_MostFrequent)
- Language (First, Last, MostFrequent)
- FirstSeen_Date > Year, Year_Month, Month
- LastSeen_Date > Year, Year_Month, Month
- Age = Last-First in days
- Alive? Dead if LastSeen > TODAY()-7
- Longest Uptime
- Longest Downtime
- Total Uptime
- Total Downtime (before "death")
- Average downtime duration
- Number of downtimes
Ideas for questions:
- Are titles/languages changing? How Many Titles/languages does a service have on average
- How long are downtimes in general? What is the probability that a service is coming back after 1,2,3,4 days ...
Would be cool if the aggregate table
serviceswould already contain interesting dimensions:Ideas for questions: