I’m trying to calculate two things in Make.com from an Iterator:
- Average: Calculate the average of a numeric field (e.g.,
price
). - Maximum Date: Find the latest (maximum) value of a date field (e.g.,
trade_time_r
).
Constraints:
- I do not want to use a Router path to split the operations.
- I attempted to use the Table Aggregator, but it does not seem to provide numeric aggregation functions like Average or Maximum.
- The Numeric Aggregator works, but I can’t add two separate aggregations (average + max) after the same iterator because the second Numeric Aggregator does not see the Iterator data.
My Questions:
- How can I perform both average and maximum calculations without splitting the data using a Router?
- Is there a way to combine these aggregations into a single module or a straightforward solution to process both results together?
Additional Info:
- I’m processing grouped data using the
order_ref
field. - I want a clean and efficient setup without duplicating paths unnecessarily.
Any suggestions or workarounds to achieve this would be appreciated! Screenshots attached for reference.