Several of us cannot figure this out and we hope it is a simple answer that we are overlooking.
We have created a Dashboard to show contributions for the last X number of days. But, we cannot get it to pull Pledge Payments.
A predecessor created a custom report that pulls in Pledge Payments, but we are having a tough time grabbing the same field in Analytics.
See two attached screenshots of the same period. One is Analytics and the other is the Custom Report. (I should note that we are not SQL experts nor access the report set-up)
Thank you everyone for the responses. Using Brian Parker (Past Member) Finance Cube idea worked for what we needed. I agree that the split between the Contribution Cube and Finance adds some challenge, but at least we answered our initial question!
I've used the Contributions Cube to identify Pledges with a balance due.
Settings:
Filter by Pledge Status (Open Pledge, Partially Paid Pledge) and Balance Amount > $0..
The Total Pledge is SUM([Amount]. The Pledge Amount Received is SUM([Received Amount]). The Balance Due is SUM([Amount] - SUM([Received Amount]).
Also, I could've just used the Balance Amount Value instead of using the Amount - Received Amount formula and get the same result.