I've an app that uses a spreadsheet like sheet for issues analysis. Issues are extracted from Jira.
There are zero values I need to show so the solution to untick zero values in add-ons->data handling->include zero values isn't working for my case.
I've multiple automated tests results columns and need to show only failed tests when pushing a button on the main dashboard, to open the analysis sheet with failed tests filtered to show those rows that aren't zero.
You can have a KPI object or button linked to a sheet with with a straight table that contains only failed tests. In the expression of the failed filed, include "If(Failed = 1, Failed)". Lastly, make sure that the column (Failed) doesn't display null value.