New Tile / Tile Properties window
This window allows you to specify properties for a new or existing Counters widget tile. It contains the following fields and controls:
NOTE: If you (or other Settings App users) previously saved a tile style as default, the new tile's properties are populated with default values.
Name - the tile name, which identifies it in the Counters Widget Properties window.
Align - the tile position within a row: Left, Right, or Entire Row.
NOTE: When you want to display two tiles within a row, the first tile must be aligned left, and the second right.
Spacing - the vertical spacing in pixels, which effectively determines the tile height.
Color - the background color for the tile.
Data tab - specifies the content for the tile's Label, Metric, and Trend. It contains the following fields and controls:
Text - specifies a static text that will be displayed in the tile. Most likely, you want to use this mode for Label.
SQL Script - specifies a custom SQL script. Most likely, you want to use this mode for Metric and Trend. In these cases, a SQL script must return a number, for example:
SELECT COUNT(*) FROM Computers
NOTE: You can use the <Current User> and <Current Organization> placeholders in the SQL script.
Display Properties tab - specifies the tile layout and contains the following controls:
Layout - the order in which a label, metric, and trend are displayed within the tile.
Trend Calculation - a format for calculating Trend:
Previous Metric - displays Trend as is, i.e. as specified in the Data tab.
% of Previous Metric - displays the ratio between Metric and Trend. Formula: (Metric/Trend)*100 (%).
Increase - displays the increase of Trend relative to Metric.
% Increase - displays the percentage change between Metric and Trend. Formula: (Metric/Trend - 1)*100 (%).
Trend Symbol - specifies signs for displaying Trend direction.
Symbol Position - a position of a Trend Symbol: left or right to the number.
Decimal Digits(for Metric and Trend) - the number of decimal digits for displaying numeric values.
Font - the font for Label/Metric/Trend. The Set Font button opens a dialog box where you can specify the font.
Align - the alignment for Label/Metric/Trend within the tile: Left, Right, or Center.
Save Style as Default - saves the current tile properties as default values for new tiles.
NOTE: The default style is saved globally for all users of the Settings App.
Refresh Preview button - refreshes data in the Preview section, where you can see how the tile will look according to the specified settings and the data it is built on.