Hello @AbhijeetPatil
I writte this blog that help Using IdentityNow Workflows to Send a List of Uncorrelated Accounts After Aggregation - Content / Community Blog - SailPoint Developer Community
The usecase was to send a notification after each aggregation.
Also it explain how to filter for specific sources.
In that trigger I also filter on Success aggregation but in your case you have to filter on success like :
$[?((@.source.name in ["My source 1", "My source 2", "My source 3"]) && (@.status != "Success"))]
or
$[?((@.source.name in ["My source 1", "My source 2", "My source 3"]) && (@.status != "Error"))]
Just check the exact name of error status.