Manage Columns

Columns Management

Note

This tab is only available with the Application type Kelvin SmartApp™

Column Settings

Asset-centric tables developed by Kelvin bring many more advanced features to the lists to give you greater control in setting up the right overview experience to streamline your workflow. This includes being able to incorporate specific Recommendations and Control Changes into the lists with direct links to control the Assets.

When you click on the button you will get the Configuration Table options come up;

You will then see a new option bar open up on the right hand side.

There are a number of options available to customize the asset-centric table.

Column FreezeHide ColumnsColumn StatisticsSearch Columns

When you are inside the column settings you can freeze columns left and right. This ensures the columns will always show, even when you scroll left or right to see all the columns.

When you are inside the column settings you can show or hide columns to ensure you only see what you need to see.

When you are inside the column settings you can see an overview of the columns available and showing.

When you are inside the column settings with a large number of columns, this feature is useful to find columns and to hide the hidden columns from the list to make it easier to see what is relevant.

Add Custom Columns

You can add a number of customizable columns to the Asset Table list by clicking on the Add Column button.

Each type you select can be customized to only the information that you required. This is especially useful if you want to have the same content type in multiple columns showing different types of information.

App ParameterAsset PropertiesData StreamLast ActionRecommendationsSchedule

You can select which App Parameter in the Configuration is shown in the Column.

On the table the Parameters are read only. If you want to change a Kelvin SmartApp™ Configration Parameter for an Asset, you need to go to the Configurations Tab.

Option	Description
App Parameter Name	Options available will depend on the Kelvin SmartApp™ itself.

Assets have a special section called Asset Properties.

This is a client custom configuration that can hold any type of information useful for clients. It does not affect Kelvin in any way.

In this setting, you can select the properties to show in the column. This is a list of all property names available across all Assets.

Option	Description
Asset Property Name	This is the name of the Asset Property Name to display it's value for each Asset in the column. If this property does not exist for an Asset, then it is left blank in the row.

You can select a Data Stream to perform a number of different types of aggregation functions on the Asset / Data Stream pair.

Option	Description
Data Stream Name	This is the name of the Data Stream to reference. You can only pick one Data Stream per column. When processing, this will pick relevant information that is associated with the Asset / Data Stream pair.
Aggregation Function	Options are; Count, Mean, Sum, Max, Min, Last This is what information will be displayed. Each one is self explanatory and will be associated with the Time Range option to produce the required information for the column.
Time Range	Options are from Last 5 minutes to Last 7 day. This is the time range that will be used to perform the aggregation function selected above. In cases where you select Last and there is no data available or the Asset has not pair with the Data Stream in the time range, then you will see N/A.

You can select to monitor the last action type that has occurred for each Asset.

Option	Description
Action Type	The type of action to monitor. i.e. Control Change
Additional Options	The options available will depend on the type of Action you chose above.

You can select which Recommendations associated with a Kelvin SmartApp™ over a defined period of time to be shown in the column for each Asset.

There are also a number of mandatory and optional filters you can select to focus the information shown in the column.

Option	Description
Recommendation Types	Options are; The recommendation types list (it is customizable by the client, so will be different for each Kelvin Instance. This will filter the Recommendations shown to only those that are selected here. This option is optional and you can multi-select many types.
Status	Options are; Pending, Accepted, Rejected and Expired. This will filter the Recommendations shown to only those that have a certain status. This option is optional and you can multiselect many status.
Range	Options are; a Time range from 5 minutes to 7 days. This will only look for Recommendations meeting the options above within a defined time range.

You can select which Schedule associated with a Kelvin SmartApp™ over a defined period of time to be shown in the column for each Asset.

You can not see schedules in the past. These have already been converted into Control Changes and can be viewed with Control Change filters and columns.

Option	Description
Schedule Type	Options are; Change Once and Change and Revert. You can not view both in the same column.
Time Range	FIlter on time range from now to the future. Options are in hours and days.