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)
Hi Mark. I was running into a similar issue and what I ended up doing was creating a widget in the Finance Cube using the Total Debit Amount value. I then filter by transaction date. Here is my dashboard: https://NARWANAWP004.tessituranetworkramp.com:443/app/main#/dashboards/5e559ad6e3ead41f8c0c13a4.
The only potential issue here is that I don't think it will show pledges that have had no payments made toward them. If anyone else out there has a better solution I'd love to hear it!
I ended up going a similar route as Colleen. Using Finance Cube to show the activity in the last 7days.
I filtered by Transaction Date (Last 7 Days) and Transaction Type (Pledge,Gift, and Pledge Payment). I display the data in a Pivot Widget using with Name, Transaction Date, Transaction Type, and Sum of Credit Amount.
Cons: Is that I haven't found a way to display Contribution specific information that exceeds transcaction filter date.
**edit in bold and italicized.