ShowColumnStatistics: Generate Column Statistics

Tag: ShowColumnStatistics

The ShowColumnStatistics function shows statistical data from columns in the grid.

These columns are added through from the grid menu (EZ Suite products) (1), from the right-click menu (2) or from the Global tab of the ribbon (sapio365) (3).

These columns are added through from the grid menu (EZ Suite products) (1), from the right-click menu (2) or from the Global tab of the ribbon (sapio365) (3)

Tag Attributes

Attributes	Value Description
Target	Identifies the grid by name Optional: if omitted or use "grid" for main grid No target necessary in sapio365
Type	Stats type identified by number: 01: three-sigma distribution 02: percentile groups 03: top and bottom 5% distribution 04: value range groups 05: % of value range 06: % of value 07: count three-sigma 08: count three-sigma groups 09: count percentile groups 10: count top/bottom distribution
ColumnID	Column ID shows the columns if they're not visible. It selects the column like <SelectColumn ColumnID="..."/>

Attributes

Value Description

Target

Identifies the grid by name
Optional: if omitted or use "grid" for main grid
No target necessary in sapio365

Type

Stats type identified by number:

01: three-sigma distribution
02: percentile groups
03: top and bottom 5% distribution
04: value range groups
05: % of value range
06: % of value
07: count three-sigma
08: count three-sigma groups
09: count percentile groups
10: count top/bottom distribution

ColumnID

Column ID shows the columns if they're not visible. It selects the column like <SelectColumn ColumnID="..."/>

Example Scripts

XML

<ShowColumnStatistics Type="02"/>

A column must be selected

XML

<ytriaAutomation>
	<ShowMyDataDrivel>
		<!--SelectColumn ColumnID="SIZE"/-->
		<ShowColumnStatistics Type="02" ColumnID="SIZE"/>
	</ShowMyDataDrive>
</ytriaAutomation>