Create overview of empty cells per field

Fri, 29 Apr 2016 16:07:35 GMT

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 :

Any feedback would be GREATLY appreciated

Re: Create overview of empty cells per field

sunny_talwar — Fri, 29 Apr 2016 16:45:46 GMT

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)))