Stat Tile
Stat Tile
The Stat Tile shows one headline number the way a dashboard card does: the value in large type, a caption such as "Open invoices" or "Total due", and an optional icon and details line. It is a display field for dashboards, home pages and status forms. The number can come from a value you enter, from another field, from a variable that counts or totals records, or from a column of a Data Source field. Color thresholds change the card's colors when the number crosses a limit, and the whole tile can run an action when clicked.
Settings
Value Source - Expression takes the number from the Value setting. Data Source column takes it from a Data Source field on the form.
Value - For Expression: a number, a {field} reference to another field on the form, or a [variable] such as a count or total from the record. Text that is not a number, such as N/A, shows as typed. While you design the form a blank value shows 1,234 so you can see the tile.
Data Source, Value Column and Aggregation - For Data Source column: pick the Data Source field that gathers the rows, say which column to total, and choose Sum, Count (rows), Average, Minimum or Maximum. When the Data Source returns rows with named columns, enter the column name, or leave it blank to use the first column. When it returns chart data, the label and value pairs that the chart variables produce, leave Value Column blank to total the values, or enter a position such as 2. Count ignores the column and reports the number of rows.
Filters - Shown for Data Source column. Add one line per condition to count or total only the rows that match. Each line has a Column, an Operator and a Value: for example Paid Equals YES, or Vendor Equals ACME, or Amount Greater Than 1000. When there is more than one line a row must match every line. The operators are Equals, Not Equals, Greater Than, Greater Than or Equal, Less Than, Less Than or Equal, Contains, Not Contains, In List and NOT In List (separate the list values with a pipe character), Empty and Not Empty. Numbers compare as numbers, so 1,200.50 and $1200.5 are the same amount, dates compare as dates, and everything else compares as text without regard to case. The Value can be a {field} reference, so a dropdown on the form can drive the tile: a Vendor dropdown named Vendor Pick and a filter Vendor Equals {Vendor Pick} makes the tile total whichever vendor is selected. With no filters every row counts. When the filters match no rows, a Count or Sum shows 0 and an Average, Minimum or Maximum shows a dash.
Several tiles can share one Data Source with different filters, so one query feeds a row of tiles: total invoices, paid invoices, unpaid amount, one vendor's amount.
Caption - The text under the number, usually what it measures. Details is an optional smaller line under the caption, such as a comparison or a date range. Both replace {field} and [variable] tokens when the form loads.
Icon - An icon shown beside the number.
Run an action when clicked - Turn this on to make the tile clickable. The same action settings as a Button appear, so the tile can open a search, open a record, run an Action Set, open a web link and so on. Leave it off for a tile that only informs.
Display
Layout - Value above the caption or Caption above the value.
Icon Position - Right or left of the number.
Value Size - The size of the number in pixels, from 16 to 80. The icon scales with it.
Decimal Places, Format as Currency, Prefix and Suffix - Round the number, show it as currency in the site's currency, or wrap it in text such as a unit before or a % sign after.
Draw as a card - On to start: the tile draws its own border, background and padding. Turn it off when the tile sits inside a Panel that already draws the card.
Fill Container - On to start: the tile spans the full width of its column or grid cell, and its full height in a grid that stretches its tiles, so a row of tiles lines up as equal cards. Turn it off to size the tile to its contents and place it with Field Alignment.
Color Thresholds - Ranges of the number with a text color and a background color for each. Leave From or To blank for an open end, so "To 0" catches negatives and "From 100" catches everything at or above 100. The first matching range wins. When no range matches, the colors from Fonts, Colors, and Borders apply, and those settings also set the border color and rounded corners.
With Fill Container off, Field Alignment places the tile at the left, center or right of its space. On a dashboard laid out with Flexible Columns in its Grid layout, several Stat Tiles in one row make a summary strip; give each its own Grid Placement when one should be wider.
Using the number elsewhere
A reference such as {Open Invoices}, using the tile's Field Name, gives the tile's number without formatting, so a label or another tile can build on it.