I have a Notion search objects componenet. One of the fields for this objects is “Amount”.
I’m trying to get the lowest amount (Min), the highest (Max) and the average.
The only way I managed to get close is by using the Numeric aggregator but that seems to be limited to only one result (either Min, Max or Average)
Hi @Matan,
You can use router and add different routes for the numeric aggregators you want, after the aggregator, use the Set variable module to save the value, later on, use the Get variable module to retrieve the data.
You can take a look at the video in this page Magic Formula to Solve Complex Problems in Make/Integromat – Excel In PPC, it shows almost exactly what you are looking for.
Hope this help!