Skip to main content
New

Event divided by event issue when 0 divided by 0

Related products:Data Management
  • Daniel Finlay

Hi

I have some graphs which track the number of occurrences of A out of the total number of occurrences.

The formula and graphs work great except for one issue. if in a particular week/month there are zero occurrences, the formula has to calculate 0 divided by 0. It seems to assign this to the value of zero.

However, this can be unhelpful as I then have to dig into it to see if it is 0 because there were no occurrences or if there were occurrences but none were A.

 

I’ve exported the data and drawn a similar graph on Google Sheets. In these cases, GS simply does not plot a point when the total number of occurrences is zero. It would be good if Amplitude did the same.

 

Thank you

0 replies

Be the first to reply!

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings