Skip to main content

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

Be the first to reply!