How to Calculate Aggregate Functions Per Unique Event Property?

  • 1 October 2021
  • 0 replies

Hi There,


I hope someone can help me with this issue. The case is this:



We have a tool that makes people fill in surveys. We want to calculate aggregate functions per survey, like median, average and the distribution.

The survey has multiple steps the user can take:

  • Start the survey
  • Click a previous button
  • Click a next button
  • Finish the survey

What we, for example, would like to calculate is the following:

‘The average ‘Previous Button Clicks’ per survey’

How we calculate this now is just simply by deviding the total number of finished surveys by the total number of previous button clicks. But this will not result in the right average number, because it is possible to start a survey, click previous buttons and not finish the survey. This will always result in a higher number than the actual number, because the ‘Previous Button Clicks’ of surveys that are not finished are also taken into the equation.


So, I don’t want to measure the data from surveys that are not finished.


How do I do this? I think I need to add event properties like ‘surveyId’, but even then I’m not sure how to do this in the Insights Report.

Any help would be highly appreciated!


0 replies

Be the first to reply!