• Replies 2 replies
  • Subscribers 702 subscribers
  • Views 89 views
  • Users 0 members are here
Options
Related

Jump to dashboard issue

Lou Ambrose
$organization

I apologize if this post is redundant. I am still getting the hang of this forum. I have a widget that shows two columns of numbers. The first is for al donors to a specific year. The second is the number of those donors who also had a gift in the previous year. Like this

When I click on the second number and jump to the constituent list it shows all of the donors (5918), not just those with gifts from the previous year (2649). I want to create a list of the donors in the second column. How can I do this? Thanks for any help!

Parents
  • $organization

    Hi Lou,

    Due to the nature of the formula, Analytics can't retrieve the constituents behind that count of renewed from last year value. If your only goal is to make a list, try a widget filtered to 2018, with a formula flagging those who gave in 2017. Then jump to _Constituents from there...

    IF( ( [Total Amount] , [Campaign Fiscal Year = 2017] ) > 0
     , 1 , NULL )
Reply
  • $organization

    Hi Lou,

    Due to the nature of the formula, Analytics can't retrieve the constituents behind that count of renewed from last year value. If your only goal is to make a list, try a widget filtered to 2018, with a formula flagging those who gave in 2017. Then jump to _Constituents from there...

    IF( ( [Total Amount] , [Campaign Fiscal Year = 2017] ) > 0
     , 1 , NULL )
Children