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