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
Welcome the
Dynatrace Community Forums
Check out the Forum User Guide and Forum Guidelines to learn how to get started.Community Member of the Month
September 2017
Announcing Dynatrace's Community Member of the Month for September 2017, Tarun A.! Click here to read more! 
