When I add a dimension alongside the Yes/No boolean value, we see one row:
If I remove the dimension, leaving filters untouched, there are two rows all of the sudden:
The SQL behind the query returns one result correctly, which means this is between SQL layer and data result tab layer.
Workaround for the time being: add other dimension and hide it
Solved! Go to Solution.
The dimension is filled in the second screen shot. If you remove the fill, are the results correct?
The dimension is filled in the second screen shot. If you remove the fill, are the results correct?
Yes, I tried that after I submitted the topic and of coruse it goes away but I still don't think we should have to remove yes/no filled values. Or perhaps I didn't expect it to work on anything other than time-related fields..