Altru Ideas

We value your unique insight into our products and services and often receive ideas and feedback from our community in a variety of ways. To streamline this process, we’ve created an idea bank where you can post product suggestions, vote for those most important to you, and add comments to existing ideas.

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
  • Jan 4 2016
  • Attach files
  • +4