Querying with Distinct Counts
I have a Revenue report that I produce twice weekly. For this report, I need Revenue to date, number of gifts and number of actual donors for current year and last year at the same time. Some of our donors give multiple times so the data that I need may be more donors than gifts. Currently, I am able to get the revenue and number of gifts. I am not able to get the total number of individual donors because the query tool does not offer a "distinct count" option. Would it be possible to add a "distinct count" option to the query tool so that distinct counts would be possible?
Guest
