Hi
I am looking to modify the TR_ANALYTICS_DIVISION_ELEMENT table so that the Current FY Giving Range and Last FY Giving Range reflect what we consider to be a donor's current and last year giving (which includes specific types of soft credits). We have a custom view that stores this information. I am planning to update the Data From field to reference this custom view (dbo.V_CUSTOMER_WITH_PRIMARY_AFFILIATES q join dbo.lcv_sfo_fy_amts c on q.expanded_customer_no = c.customer_no) and will leave the Data Where column empty. For the Data Select column, do I need to add !. to the beginning of the column name since it is a non-aggregate expression? Similar to how it is built in TR_QUERY_ELEMENT?
ThanksJess LevySan Francisco Opera415-551-6319
Hi Jess,
No "bang" required. The value does need to be aggregated, whatever the column is, and assuming it's you'd sum it, so your data_select would be something like SUM(c.amount) . If it's preaggregated int dbo.lcv_sfo_fy_amts, then you could take MAX(c.amount) or AVG(c.amount).
Best,Chris
Chris Wallingford Director, Business Intelligence Tessitura Network Office +1 888.643.5778 ext 553 chris.wallingford@tessituranetwork.com Tessitura Learning & Community Conference July 28-August 1, 2019 #TLCC2019
Thanks for the speedy response!