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!
HI Colleen - can you export your dashboard? Thanks!
Yep, sorry! Does this work: /cfs-file/__key/communityserver-discussions-components-files/468/0601.WeeklyCampaignComparisonReport.dash