TbeckDK
1 Nickel

DPA Report Challenge

Jump to solution

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 2GB Backed up Day 3GB Backed up Day 4
Client120111
Client2130011
Client31140001
Client411150000

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

0 Kudos
1 Solution

Accepted Solutions
Highlighted
Michael_Real
1 Copper

Re: DPA Report Challenge

Jump to solution

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.

1 Reply
Highlighted
Michael_Real
1 Copper

Re: DPA Report Challenge

Jump to solution

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.