Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have many fields for which I have to decide dynamically if I want to sum it or average it.
like if(aggregation='Sum', sum(field), average(field))
where sum(field) is for 20 fields and same is for average..
is there any way I can say, $(aggragation(field)) and aggregation is sum or average based on condition?
--aggragation= either sum or average--
You should be able to use this