Conditional aggregate functions

As an ETL developer, I would like Data Fusion to provide conditional aggregation functions out of the box, so that I can add aggregations in my data pipelines without having to add extra logic to filter data prior to the aggregation node.