Given an event X, that has the property with a key Y and value V, how can I pull a report that sums all values V for event X and key Y?
Best answer by scottk
You should be able to do this in Insights designer using the "add aggregation" feature. With the new UI enabled 1. Select event X 2. Click on the the 3 dots 3. Select "add aggregation" for property Y.
You should then see the `Sum` aggregate function used to sum the values of property Y. You my need to typecast the property if it is not naturally an integer value.