Creating a report with a custom 15 min resolution
I'm creating a report for our synthetic transactions, and the customer wants to have the availability figures reported using a 15 minute resolution. This is because all of our synthetic transactions are scheduled on a 15 minute basis.
The design sketch I have from him is similar to this (with a time range set to the last hour):
| Availability (total) | Region 1 | Region 2 | ||||||
|---|---|---|---|---|---|---|---|---|
| :00 | :15 | :30 | :45 | :00 | :15 | :30 | :45 | |
| Application 1 (site problem with Region 2) | ? | ? | ? | ? | ♦ | ♦ | ♦ | ♦ |
| Application 2 (all fine) | ? | ? | ? | ? | ? | ? | ? | ? |
| Application 3 (app problem on all regions) | ? | ? | ♦ | ♦ | ? | ? | ♦ | ♦ |
The report I have come up with is looking like the following at the moment:
| Client Region | Region 1 | Region 2 | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Time | :00 | :05 | :10 | :15 | :20 | :25 | :30 | :35 | :40 | :45 | :50 | :55 | :00 | :05 | :10 | :15 | :20 | :25 |
| Transaction | ||||||||||||||||||
| Application 1 | 100%? | - | - | 100%? | - | - | 100%? | - | - | 100%? | - | - | 0%♦ | - | - | 0%♦ | - | - |
| Application 2 | - | 100%? | - | - | 100%? | - | - | 100%? | - | - | 100%? | - | - | 100%? | - | - | 100%? | - |
| Application 3 | - | - | 100%? | - | - | 100%? | - | - | 0%♦ | - | - | 0%♦ | - | - | 100%? | - | - | 100%? |
As you can see, the transactions run at various times during the 15 minute interval. Is there a way that we can aggregate on a 15 minute interval bases?
Note: The question marks are supposed to be circles and diamonds
