Solved

Insights: how to sum property value?

  • 27 November 2019
  • 1 reply
  • 251 views

Badge
  • New Participant
  • 0 replies

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?


icon

Best answer by scottk 28 November 2019, 12:43

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.


View original

1 reply

Userlevel 4
Badge +2

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.


Reply