Hey folks,
We are looking to pull a report of constituents who's 'Received Amount' is $1,000 or greater for one of our campaigns. We're doing this through Analytics. We create a dashboard, then a widget, and filter that widget by '2022 Ocean Commotion'. We also filter by 'Received Amount' > $999. We pull in rows of Constituent ID, Constituent Display Name, and a value of 'Received Amount'.
The Grand Total comes to $339,574.25. That seems fine. Then we link this widget to the 'Constituents' Jump_to dashboard.
If we filter by Constituent ID descending, we see the largest ID is 1009814.
When I click the 'Grand Total' number, it brings up a list where the largest Constituent ID Is 1012204.
The jump_to list isn't pulling in all the filters- it's not filtering by the 'Received Amount'. The jump_to list is pulling in more constituents than the widget is. Why is this the case? I know that the widget -> list functionality doesn't respect custom formulas, but I thought that in the past it would pull in all filters on given widget. Is that not the case? I haven't found anything in the documentation that's helpful.We've had to pull the list into a CSV, then upload that as a list, then run that through an Extraction. Are all those steps necessary?
I should note - when I pull the list from the widget (by clicking the Grand Total number), the 'Received Amount' Filter is not there, but the campaign filter is.