PSDio - IQ - Lybunt Query Per Fund and Per Org

Purpose of This Query 

This query will give you a Lybunt/Sybunt results for specific funds. There are four pictures below to help you build this query, the first two are the columns and the second two are the conditions (with the second picture of conditions being the subquery).

The query conditions start with a subquery, what this subquery does is says "Show me all the families that don't have a pledge to a certain fund." So this could be your 2017 fund, so you are asking for all the families that haven't given to 2017's fund. From there you are going to ask, "Of those families who didn't give to the 2017 Fund, who has given to the 2016 Fund?" 

 

Columns #1

results_1.jpg

 

Columns #2

results_2.jpg

 

Conditions

fund_conditions.jpg

Subquery

fund_subquery.jpg

 

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.