Count "Having No Value"

Hi all, “new builder alert here” hoping someone can help. Is there a way to display an aggregate count of a choice field where the choice has “no value”. I’m using it as a check field on data that has been imported so want it to display where there is no value imported in that choice field. I can see how to display where there are values and where there are distinct values but nothing for where there is no value. Any help you can give would be great!

1 Like

I think i have done this. I added a subset to the aggregate composite to only count if the field is empty.


Hi Rhian
Welcome to the Community forum!
I believe one way to achieve this would be by setting up a check to see if the value was empty on imported data, a subset for empty values imported. The aggregate should be restricted by the subset.

1 Like

Thank you will give that a try