Skip to main content

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  

 

 

 

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 :)  


Reply