I'm trying to put together a widget with people who have given at least $125 each year over the last three years. I've been able to get my values to filter to only show those above $125, but my widget filter of amount >= isn't applying across the board. Anyone know how to adjust this so I only get people who have given at least this much in each year? Here's what my widget looks like now:
Thanks!Anne
You might need to do a widget filter for each of those custom Values (22, 23, 24). I think that will convince the widget to say "show me only people who've given more than $125 in 22, and more than $125 in 23, and... (etc.)".
I tried to do a filter on the values, but it won't let me filter by amount. How do I add a widget filter specific to the year?
Once you build out your custom Value, filter form that Value block like you would a normal Value filter:
You'd set the floor for that new formula at 125, then repeat for each other Value/year.
Duh. I'm not sure why I had a brain fart on that one. thank you!