This post is more than 5 years old
1 Rookie
•
20 Posts
0
834
November 1st, 2012 01:00
DPA Report Challenge
Hello
Every day I do a backup of 20 clients.
Now I need DPA to report to me the largest backup of the month for every single client and in the end add up these results and send me the report.
Is this possible at all?
It is important that it is the biggest amount for each client per month.
if example is needed:
| Client Name |
GB Backed up Day 1 |
GB Backed up Day 2 | GB Backed up Day 3 | GB Backed up Day 4 |
|---|---|---|---|---|
| Client1 | 20 | 1 | 1 | 1 |
| Client2 | 1 | 300 | 1 | 1 |
| Client3 | 1 | 1 | 4000 | 1 |
| Client4 | 1 | 1 | 1 | 50000 |
Now I don't want a result that says 50003 (1+1+1+50000) which is the sum of day 4.
What I need is a report with the result 54320 (20+300+4000+50000) which is the largest backup for every single client for a period of time all, added together.
I really hope someone can help me on this.
I use DPA v. 5.8.4
Thanks
/Tommy
No Events found!
Michael_Real
4 Posts
1
August 18th, 2013 17:00
This should be relatively simple,
It requires using the "GroupBy" Operator found in the Aggregate section
Your source data would be the table "Backup Job Details"
Your then group the source data by "client, setting the "default Number Operation" to Max
If you just wanted one line of the report showing the Total number of all clients you can add another GroupBy operator with the "Default Number Operation" set to Sum this time.
Otherwise you can add a Total field in the report to add all the clients up.