New Tessitura user here and am hitting some roadblocks. Any help would be greatly appreciated!
I am needing a list of any donor (or foundation, trust, etc.) and their cumulative donation amount within a specified window of 14 months.
Thank you!
Great, thank you Jenny! I will forward this to our IT department!
Thanks again!
Elisabeth
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Jenny Graf Carvo Sent: Friday, November 11, 2016 9:56 AM To: Elisabeth Alonzi Subject: Re: [Tessitura Development Forum] Cumulative donations in a 14-month window
Hi Elisabeth!
You'll want some help from your IT folks but you can pull this from an output set. Output sets are cool because you can create new, custom elements to get the data you are looking for. I created one in our system just like this. I may have found it in one of the handy dandy Output Set Cook Books. Here's what you can pass along to IT. Once they add this for you, it'll be available for you to select when you build a new output set.
Add a row to TR_QUERY_ELEMENT:
data select: sum(cont_amt)
data from: vs_contribution
data where: cont_dt > dateadd(mm,-14,getdate())
Hope this helps! Feel free to let me know if you have more questions about this!
Jenny
From: Elisabeth Alonzi <bounce-elisabethalonzi8009@tessituranetwork.com> Sent: 11/11/2016 1:07:52 AM
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!