Is possible to perform more complex calculations using a mixture of tables, without making one table a subtable of another. Specifically, I’m looking to create summary tables that can pull data from multiple tables for more complex aggregation/calculation.
For example, if we have a sales table, stock table, we may want a summary table to include fields that aggregate from both stock and sales table beyond just basic Sum/Count. (I can see that there’e Aggregation Functions but they are only simple aggregations)
I don’t think I want to make the tables as subtables of the summary table, as I may need to use it for other calculations elsewhere.
I did look at aggregated field but it looks like it can only do Count,Total,Min,Max,Avg.
it also requires me to create a linked field first rather than just allow me to do the aggregation.
More importantly, I would like to be able to use functions such us COUNTUNIQUEIF, SUMIF, QUARTILE, STDEV etc.
Is there any way to do complex aggregations?
My understanding is that if I have a few summary tables that I want to do similar aggregations, I will need to create a different link field for all of them, is that right?
To aggregate numbers from another sheet, a linking relationship (linked field) is required, and we now only support count, total, min, max, and average calculations.
If you would like to aggregate without link and load or apply different complex aggregations, you may try using JavaScript workflow and see if it will help.