I have a graph with rows that represent names of tests and to their right the names of the types (models) on which the tests are done. In each model you can see in red the number of failures found in it.
The problem is that I was not able to create a filter that shows me only the tests where there are 0 failures, like the test I marked for you with a black circle and arrow.
Right - sorry @Itay Goldshtein - I see what you mean.
You could try a calc "Failed Executions (excl. type)" =
{EXCLUDE [Type]: SUM(Failexecutions)}And then drag that onto filters and do the at most = 0 filter.
This uses a LOD (level of detail) expression. There are some things to be aware of here - you're asking Tableau to ignore or only work at a level of detail that differs from your view, which means filters can be ignored (check out Tableau's order of operations, or Jim Dehners blog on different filter types for more on this btw). An alternative to EXCLUDE is FIXED.
{FIXED [Testname]: SUM(Failexecutions)}But this will likely ignore a heap of filters I think I see in your view.
Ta, Steve.
