I volunteer for a NGO and we try to accomplish the following: we want to aggregate the sum of all current recurring contributions (of type=X) over all members. It doesn't matter what status they have (paid, pending...) but one member should only be counted once. It's a snapshot with the result of one single value of all the recurring contributions, so to say.
I looked through the available reports in the dashboard and went through the different API methods. It seems like it would be possible to get all contacts through the API and then loop over their contributions (complexity!) to aggregate the sum, but I thought there would be a nicer way?!
Any recommendations on how to accomplish this? Any hint is appreciated, thanks!