Hey there! Has anyone created a BI dashboard that shows what percentage of total giving was done by Alumni (whether they were hard or soft credited)?
So, if all gifts totaled $1M and $100K was given by alumni (hard-credit) and another $100K was given by alumni (soft-credit) I'd want it to show that 20% of the total gifts were alumni donations.
I brought in two spreadsheets- #1 was all our alumni with constituent ID and #2 was all the gifts with the donor constituent IDs and the constituents IDs for all soft-credited gifts. I tried tying all ID columns together but that's not getting me anywhere. Am I on the wrong path to do this?