Answering my own question.
Everything works by replacing transfrom_aggregate() by transform_joinaggregate()!
transfrom_aggregate()
transform_joinaggregate()