Adjusted Gifts in Dashboard Queries

Options
We have a dashboard that summarizes gifts to a disaster relief fund.  One of the panels is an Appeal query that summarizes the total amounts raised for the fund by appeal.  However, we had some gift adjustments (e.g. entered as Gen Op fund and then adjusted to disaster fund);  The query is double-counting those gifts in the dashboard.  So if we received $25,000 in unsolicited gifts for the disaster, but $1,000 was originally put into gen op and then was adjusted, the dashboard total shows $26,000.  Is there some way to filter out the original or adjusted amounts so that it’s not duplicating some of the gift amounts?  Or perhaps there is a better way to summarize the appeals on a shared dashboard?  Any help would be greatly appreciated!  Thanks!

 

Categories