Dividing the sum of an event property by the sum of another event property

  • 3 August 2023
  • 2 replies

I’m trying to come up with a new metic that is the sum of one event property divided by the sum of another property. 

In my example, I want the total sum of visits that have been confirmed / by the number of invoices that have been created. Batch size is the property that contains the number of visits / invoices. But i don't seem to be able to add them to a formula, when I did, it switches to group by not sum. 

Is there a way I could achieve this calculation. So I can see what % of visits have an invoice

Any help greatly appreciated  





Best answer by Saish Redkar 3 August 2023, 16:39

View original

2 replies

Userlevel 7
Badge +10

Hey @Brendan Dunn 

Did you try using the PROPSUM formula with your events as seen in this demo chart?

Hey @Saish Redkar

I think that's exactly what I needed to thank so much :)