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
JANUARY 15, 3:00 PM GMT / 10:00 AM ET