Create overview of empty cells per field

[#1]

Hello

I would like to create an overview in the layout(preferably a table) containing all the fields in the rows and the number of empty cells as measure.

An important note: the number of empty cells should be dynamic (when adding a filter, it should change)

fictive dataset:

ID	description	Person	Measure
1	table	Harry	ST
2		Olga
3	Screen	Eduardo

Preferred outcome table in the lay out (but WITH dynamic :

Field	Null values
Description	1
Person	0
Measure	2

Any feedback would be GREATLY appreciated

[sunny_talwar]

Check the attached out:

I can't find the thread, but this expression was proposed by someone else

$(=concat('if($Field=' & chr(39) & $Field & chr(39) & ',nullcount([' & $Field & '])', ',') & concat(right($Field&')',1)))