Improve how the app handles division by 0 calculations
development queue
Dan Lapuz
Make division by 0 calculations get fixed automatically or display proper information instead of showing "no data" which can confuse clients.
When clients create calculate layers for "current" data (Current month, day, week) there are periods where the widget appears as "no data" because at the start of these periods, usually a variable is zero. This leads to clients reporting tickets saying their widget is broken.
To circumvent this issue, we an apply the statement: CASE WHEN {denominator} = 0 THEN NULL ELSE {formula} END
However, the issue with this is that during client trainings or demos, clients in general are not familiar with postgresql. This leads to confusion and the notion that the app is too complex to use, leading to lower adoption and possible increase in Porfessional Service tickets.
As a user, I want the calculate layer to be simple to use without having to know SQL. If there are errors in calculations, it needs to be clear what caused the issue and steps how to fix the issue
Log In
This post was marked as
development queue
This post was marked as
open
J
Joy Li
product review