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

AttributesValue Description
TargetIdentifies 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
ColumnIDColumn ID shows the columns if they're not visible. It selects the column like <SelectColumn ColumnID="..."/>

Example Scripts

<ShowColumnStatistics Type="02"/>
XML

A column must be selected

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