Sum/average/percentage of uniques

Is there any way to only aggregate events that have an unique attribute?
For example: sum(unique(TOTAL)), or better sum(TOTAL) where ID is unique
(Yes, I really, REALLY miss the good ol’ GROUP BY)
Thanks in advance.

Hi @mwadel - the capability of using functions around results is an area where Insights could be significantly improved.


Hi @stefan_garnham. If you have any specific examples you could share, we can pass that info along to the Product team in the form of a feature request.

Hi @seth - Yes, I had already posted a sample on using an average function on this post on Concurrent users