1 of 1 people found this helpful
I suggest a series of Static Lists for each Stream such that you Add to List each time someone is moved into a Stream. You would then never remove anyone from those lists.
That would work!
Sounds like there is no filter for "was part of the program".
I know that you can get this info from the activity log on any given lead record. In another company, we created a datawarehouse that could filter for specific program adds - meaning they were ever in the program. But that was small part of the data warehouse analysis. Your way, for this simple query, is way more appropriate.