Aug-13-2020, 10:44 AM
Hello,
I have xml file with data.
What I need to do. Group data by
The result I would like to achieve could be something like this:
I have xml file with data.
What I need to do. Group data by
siteid
and merchantname
and sum totals from clicks
, downloads
, newdepositingacc
, netrevenue
, revsharecommission
.The result I would like to achieve could be something like this:
[{ 'name': 'http://gamblerguy.com (LeoMonaco)', 'clicks': 'sum clicks totals', 'downloads': 'sum clicks downloads', 'newdepositingacc': 'sum newdepositingacctotals', 'netrevenue': 'sum netrevenue totals', 'revsharecommission': 'sum revsharecommission totals' }, { 'name': 'casinochimp.com (LeoMonaco)', 'clicks': 'sum clicks totals', 'downloads': 'sum clicks downloads', 'newdepositingacc': 'sum newdepositingacctotals', 'netrevenue': 'sum netrevenue totals', 'revsharecommission': 'sum revsharecommission totals' }]