Part 2 explored active users at quarterly license reviews. Tightening up the request a bit more, are individual users normally active on an annualized basis? Is the average days between visits <=90?
1. Normally Active: 365/COUNT(DISTINCT "Query Time"."Date")
2. Again, add some conditional formatting:
- <=90 - Green Tick
- >90 - Red Cross
3. Thinking about your user activity, what you want to know when might be important. Column order improves readability of the information here...
- Active Now
- Normally Active
- Active @ License Review Date
4. The request from Parts 1 and 2 could look a bit like this...
 |
| From DR. OBI |
