Number Formatting

After R21.0.44.00, users can change the formatting of values displayed in Seeq. This change can be applied to each item and will apply to the cursor values, y-axis, and scorecard metric. 



Changing an Item's Number Format

To change an item's number format, open the Item Properties for that item. Look through the list to find the Number Format section and select Configure. This property is not propagated from one item to the next.

This will make a text box available where formatting can be manipulated and applied. There are several Predefined Formats.

  • Auto is Seeq's intelligent format option that shows a fixed number of digits and transitions between numeric and scientific notation when the number is sufficiently large.
  • Number fixes to display numeric notation regardless of how large the number may be. This formatting will never display in Scientific Notation.
  • Scientific Notation will always display Scientific Notation with the specified number of digits per the text box.
  • Significant Figures will always show numbers with the specified significant figures consistent with how significant figures are treated in scientific domains. Calculations are not affected by this setting.

Click these as a starting place to populate the text box with a "default" for each format. Then add the appropriate # or 0s to meet desired formatting. This style of formatting is the same as standard formatting in Excel. Add or modify use of commas if desired or indicate how many values to display after the decimal. Selecting the  will link you through to https://customformats.com/, a website that will let you experiment with all the possible supported formats.

For example, to add commas separating the thousands and limit to only one place after the decimal, the appropriate number format text may be as follows:

 #,##0.0;-#,##0.0;0.0;

Conditionals can also be used to change number formatting around a fixed threshold. This may be appropriate if a particular sensor has heightened accuracy in a given range and you want that accuracy to display in Seeq. In the example to the right, all values that are greater than or equal to 90 will display with two decimals after the decimal point, but values below 90 will be rounded to the closest integer. The conditional number formatting to achieve this display is as follows:

[<90]0;[>=90]0.00

Conditional Number Formatting

PI Display Digits

The PI datasource has a "Display Digitis" attribute that works in the following way:

  1. A negative number sets the total number of significant digits. For example -5 would display 1234.4321 as 1234.5

  2. A positive number sets the total number of digits to the right of the decimal. For example 5 would display 1234.1234567 as 1234.12346

As of Seeq 22.0.47, number formats will be applied to PI items that have the "Display Digits" attribute set. Items with a negative "Display Digits" will have a new "SigFig:#" number format string where "#" is the number of significant digits that will appear. Items with a positive "Display Digits" will be given a string of the form "#,##0.00" where the number of zeros to the right of the decimal place matches the "Display Digits".


For Administrators

As this number formatting is a property on signals, it can be applied to many signals through a Connector Property Transform with assistance from a server administrator.

By default on install or initial upgrade to R21.0.44.00, the global default will be "auto". If necessary, the global default can be changed by an administrator:

  • On Seeq Server version R22.0.46.00 and later, update the Features/NumberFormat option as described in Seeq Configuration and User Data Files
  • On prior versions, use the API to change the numberFormat property under the /system/configuration endpoint.