Hey Todd - I pull in program performance data through the "Leads by Program" API call. Have you looked at that one? In addition to all the standard lead fields, it lets you pull in fields specific to the lead's program membership - membership date, progression status, acquired by, reached success, etc.
I pull in that dataset with 1) lead ID, 2) program ID, and then those several membership-specific fields. Then I merge it with the full Lead record dataset and full Program dataset based on the lead ID and program ID foreign keys. From there, to do what you are talking about and keep the flexibility of changing date range, you would likely need to do some beast mode calculations... something like these columns: (I always start off with just a table card to get the data pulled together):
1. Program Name
2. COUNT(Lead ID) <= number of leads in the program
3. SUM(CASE WHEN membership_reachedSuccess=true THEN 1 else 0 END) <= number of leads that reached success in the program
4. SUM(CASE WHEN membership_acquiredBy=true THEN 1 else 0 END) <= number of leads acquired by the program
I haven't tested that, and i'm admittedly a bit rusty on my aggregations, but that might work for what you are looking for. Let me know!
.png)