beautypg.com

Group, Format, Sort – Rockwell Automation FactoryTalk Historian Classic User Guide User Manual

Page 94: Group 94, Format 94, Group format sort

background image

Chapter 5 Customizing RSBizWare Charts and Tables

To remove the aggregate function from a column, right-click the
column header, and then click Aggregate > None.

To group by field, right-click the column header, and then click
Grouping > Group 1.

The table records are grouped by the selected column. Each time you
click Grouping in the shortcut menu for additional columns,

additional group numbers are added to the menu. This allows you to
group by as many columns as displayed in your table.

To remove a grouping, right-click the column header, and then click
Grouping > None.

To apply a format to a column, right-click the column header, and
then click Format >

format style.

The format styles available on the menu vary from column to
column. Only the formats that apply to a particular column are
displayed. For example, it only makes sense to apply a month, day,
and year
format to a date field.

To remove a format from a column, right-click the column header,
and then click Format > . The column data will use the
default format for the data type displayed in the column.

To apply an ascending (A to Z) order to a column, right-click the
column header, and then click Sorting > Sort 1 > Ascending.

The table records are sorted by the selected column. Each time you
click Sorting in the shortcut menu for additional columns, the

additional sort numbers are added to the menu. This allows you to
sort by as many columns as your table displays.

To remove the sorting order, right-click the column header, and
then click Sorting > None.

Group

Format

Sort

94

Rockwell Automation Publication HIST-UM001K-EN-E-June 2014