OC Statistics

The Operations Centre screen has an Activity Panel called Statistics.   That screen shows Statistical Information for the selected 'Type'.   In that screen are two panels. 

The left-hand panel displays a Description of the Statistic along with the current value

The right-hand panel displays drilldown information that makes up that Statistic. 

 

This 'OC Statistics' screen enables you to define the content of both the Statistic panel and the drill-down panel

 

Data Display Options

 

Field Position - On this screen you can move the field position by dragging the column heading left or right to the position where you want it to appear.

 

 

Entry and Display fields

 

Company Type: From the drop-down list select the Company Activity Type.  This list shows all the Activities currently held in the OC Activities screen

 

Statistics Name: Open format entry where you can describe what the Statistic is measuring.  This name will appear in the Operations Centre's Statistics Screen

 

System Statistics SQL: This is the base System Statistics SQL that will be used if a Company Statistics SQL (see field below) does not exist.   This SQL cannot be amended BUT you have the option to copy this SQL from the drop-down panel and paste this into the Company Statistics SQL field where it can be amended.

 

System Drilldown SQL: This is the base System Drilldown SQL that will be used if a Company Drilldown SQL (see field below) does not exist.   This SQL cannot be amended BUT you have the option to copy this SQL from the drop-down panel and paste this into the Company Drilldown SQL field where it can be amended.

 

Company Statistics SQL: You can create and maintain your own Statistics SQL related to this Activity Type record.  An SQL here will take priority over the above System Statistics SQL.   You may wish to consider copying the System Statistics SQL and paste it into this field where it can be amended.

 

Company Drilldown SQL: You can create and maintain your own Company Drilldown SQL related to this Activity record.  An SQL here will take priority over the System Drilldown SQL.   You may wish to consider copying the System Drilldown SQL and paste it into this field where it can be amended.

 

Value Fields Format: From the drop-down list select the format of the displayed Values.  The options are:

Date: The display will be output in Date format as defined in your Systems Settings

Currency: The number will be preceded by the currency symbol used by your company

Value: No currency symbol will be displayed

 

Sequence: Defines the sequence - within the Company Type - that the Statistic will be displayed.  During creation of the record this is incremented by 10 within the Company Type.  However you can amend the number if required.

 

 

Buttons

 

Close: This will close the OC Statistics screen. If you have any unsaved data then you will be asked if you wish to save it before the screen is closed.

 

Add: This will send the cursor to a new line for entry of a new OC Statistics record.

 

Save: This will save the current data without exiting the screen

 

Cancel: Any changes made since the line was actioned or the last time the ‘Save’ Button was pressed will be lost.

 

Delete: This removes the current highlighted OC Statistics record.