Find all fields with all null values in data model

[ankuragrawal]

Hi All

I got a requirement to list down all the fields which are null in my data model.

Example- my data model has 30 fields out of which many fields are there in which not a single value is available in any of the cells of the field or u may say as density=0%.

How can I  proceed

[tresesco]

If Len(trim(Concat(distinct Field)))=0 then field has no value

[ankuragrawal]

Thanks

but i need count to such fields

[ankuragrawal]

if my data model has 30 fields out of which 7 are totally null then i need the count 7

[tresesco]

In UI or script?

[ankuragrawal]

UI

[tresesco]

Hi Ankur,

It is a difficult one. 🤔 But I guess I could figure out an expression for UI. Try like:

=Sum(Aggr($(=concat('if($Field=' & chr(39) & $Field & chr(39) & ',If(Not Sum(Len(Trim([' & $Field & ']))),1,0)', ',') & Repeat(')',Count($Field)))
,$Field))

[tresesco]

Hello @ankuragrawal , did you try this? Does it work for you?  

Sorry, following up because I took some time to resolve the problem and a bit excited to know the status.