I am a beginner Analytics user. I've taken a bunch of the online Analytics courses and am trying to improve my skills. One of the main issues I have with analytics is my dashboard showing different information than my reports.
For example I am pulling a Fund Activity Report with the only filter as "appeal" for a particular appeal. When I do that I get a total of $41,477.97
However, when I set up my dashboard (contribution cube) with the same filtered appeal with no other filters and add a widget for "contribution amount" I'm getting a significantly lower number $23,903
When I use the finance cube I get an even lower amount $20,119.63
I've done a bunch of playing around and making sure no other filters are present. I cannot figure out why my Fund Activity report has the correct amount for this Appeal but I cannot get a dashboard to reflect that amount.
Does this Appeal span multiple fiscal years? By default Analytics only pulls a limited number of fiscal years into its data warehouse.
When you look at the income in the dashboard, are you breaking it out by Fund like the report? Do the differences in Fund totals suggest anything?
It's a single fiscal year. I'm looking at our FY23 Year End Appeal. I did break it out by fund and it suggests that some gifts in 1 particular fund are not being included on the dashboard for some reason. I can't for the life of me figure out why though. I've been trying for several days at this point.
I also looked at contribution count. We have received 199 contributions, but only 158 are pulling into the dashboard