Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
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.
Any ideas how to do it?
If(tests_failed = 1, tests_failed)
Make sure that the status of the failed test is 1, otherwise use the exact value.
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.
the steps with linking the kpi to a sheet are very useful, thanks.
but when it comes to the formula in the data part->failed->field If(tests_failed= 1, failed) no data is shown, error in expression:
Bad field name: [If(tests_failed = 1, failed)]
If(tests_failed = 1, tests_failed)
Make sure that the status of the failed test is 1, otherwise use the exact value.
now it says invalid dimension. the status of the unfiltered data is 224 total rows, 2 rows where tests_failed = 1
wow this worked! thanks!!!
Please, mark as a correct answer so it will help others know that the issue has been resolved. Thanks