Show Table Filled

Shows how many of the table fields are filled, that is number fields that are not '0' and text fields that are not empty.

Permissions

Command Kind	Needed User Kind
Read	All

Parameters

Name	Type	Description	Required	Default	Values
Table	array of string	Name of the table ([Table]).	yes
Filter	array of string	Filters by dimension item ([Dimension].[Item]) or tree sum ([Dimension].[Tree].[Sum]). The tree sum format is equal to 'FilterTree'.	no
FilterAttribute	array of string	Filters by attribute ([Dimension].[Attribute].[Value]).	no
FilterRange	array of string	Filters by an item range ([Dimension].[StartItem].[EndItem]).	no
FilterTree	array of string	Filters by tree sum ([Dimension].[Tree].[Sum]).	no
Subtable	string	Name of the subtable ([Subtable]). A subtable contains additional filters used by the table.	no

Result

Name	Type	Description
Field	string	Name of the field.
Cells	number	Total number of cells.
Filled	number	Number of filled cells.
Percent	number	Percentage of filled cells.

Code

SHOW TABLE FILLED
TABLE=[string, Multiple, Needed]
FILTER=[string, Multiple]
FILTERATTRIBUTE=[string, Multiple]
FILTERRANGE=[string, Multiple]
FILTERTREE=[string, Multiple]
SUBTABLE=[string]