• Name – name of the Statistics definition. This is shown in a dropdown menu in both Statistics Writer when setting up a duty and in Widget config in the dashboard when creating or editing a widget. Please use a descriptive name.
• Description – description of the Statistics definition
• External URL – this will enable context based links from the widget detail view in the dashboard. See section Context based URL.
  • Setting up link from VBU to program in SmartOffice - Standard or Smart Office (M3 internal link)
• Update strategy – how the statistics table should be updated
  • Replace – Deletes all rows for statistics definition, then add current result. Useful for storing current state of an application or process.
  • Update – Updates existing rows based on KEY or DATE_KEY fields, adds non-existing rows. Useful when multiple duties write to the same statistics definition, for instance Duty A stores M3 Picking list print date in column date1 and Duty B stores WMS Picking Started in column date2, both duties use Delivery number and Picking list suffix as KEY values.
  • Add – Adds new rows. Useful when storing history, such as current CPU usage in intervals of 10 minutes
• Cleanup routine - how rocords should be deleted from the statistics table
  • None - Records are not deleted
  • Created date is older than - select between days, weeks and months
  • Last updated date is older than select between days, weeks and months
  • Query define your own delete clause to select records for deletion
• Column setup – columns can be dragged and dropped to change viewing order in widget detail view
  • Type
    • KEY used as key value. Stored as string in database
    • STRING – string / text values
    • INTEGER – numerical values without decimals
    • DOUBLE – numerical values with decimals
    • BOOLEAN – true or false
    • DATE_KEY – use when storing dates and/or date time as keys instead of KEY. Format yyyMMdd HHmmss. This should be used when for instance storing a current state of an application at a certain time.
    • DATE – use for date and/or date time. Format yyyMMdd HHmmss
  • Label – Name of column. This will display in widget detail view.
  • Column reference – Actual field in the statistics table used for storing the data.

Note – when creating a new statistics definition, the column reference information isn’t available. After creating the statistics definition, go back in to the definition to view the column references.

Example setup