DMI Report: Average functionality
I have been searching for a functionality to generate an average of your values in a generated DMI report.
Example:
The report lists the 'operation time' for a specific transaction.
The report is designed for look back for the last month and the resolution is per day. Hence, 30 (or 31) operation times should be visible in the report.
It is possible to have the DMI report to average the 30 or 31 absolute numbers of the 'operation time' i a row below - as indicated below?
| Day | Operation Time |
|---|---|
| 1 | 1 sec |
| 2 | 2 sec |
| 3 | 2 sec |
| 4 | 1 sec |
| 5 | 1 sec |
| ... | |
| Ave | 1,5 sec |
I believe that copying this section to another and changing resolution to "1 month" in the new section should do the trick. You should get the one row with average. By extending the time range you can add more rows - months.
I'm not aware of a way to do it within one section ...
