‘FALSE’ or ‘Is empty’ Filtering on metric chart block not working

Bug Reports
1

Below filter does not work for metric chart block when a check box field (as a look up field) is filtered to ‘FALSE’ or ‘Is empty’.

It does work when ‘TRUE’ or ‘Is not empty’

image

2

could you please share the app with support@softr.io and post a studio link here?

3

It is because the field is a lookup field it can show multiple times True or False, and the conditions for this field in the application won’t give you the option for Contains or Does Not Contain, just Is or Is Not.

To make this work, change the field type in the database to a Rollup field, and either

  1. choose ARRAYJOIN, that would then show the Contains etc conditions in the app, or
  2. choose ARRAYUNIQUE and under Record Options click filter and set a filter for example “show record where {field} Is false“, this will then only rollup all records that are unchecked.

It all depends on what you’re trying to achieve but either way one of those should be your solution.

4

Thanks Sam. I ended up just doing a formula with checkbox output which seemed to fix it. Seems issue was look up field