Measures
A measure turns any Business Central data into a number your team cares about: overdue invoices, open orders, stock on order, sales this month. Define it once and every Dynamic product can use it, so the same Overdue invoices measure can be a role centre tile, an email alert and a trend chart, all from one place.
Search Dynamic Measures to see them all. You can also create one straight from a product’s setup using New Measure.
Fields
Section titled “Fields”| Field | What it does |
|---|---|
| Code, Description | How the measure is identified. Every product links to the measure by its code. |
| Source Table | Any table in Business Central, including tables from other extensions, for example 21 Cust. Ledger Entry or 36 Sales Header. |
| Aggregation Type | Count the records, or Sum, Average, Min or Max a field. |
| Aggregation Field | The number field to add up, for example Remaining Amt. (LCY). Normal fields and FlowFields are both supported. |
| Filter Expression | Which records to include, for example Open=Yes;Due Date=..{TODAY-1D}. See Filters and tokens. |
| Measure Type | Standard or Per Record (see below). |
| Record Table | Per Record measures only: the table of the record being viewed, for example 18 Customer. |
| Drilldown Page | The page that opens when someone clicks the value. Leave it blank to use the table’s normal list page. |
| Enabled | Switch a measure off to pause it everywhere at once. |
Use Preview Value to check the result and Show Records to see the records behind it. Show Field Names lists the fields of the Source Table, to help write the filter.
Standard and Per Record measures
Section titled “Standard and Per Record measures”| Standard | Per Record | |
|---|---|---|
| Value | One value, or one per user if the filter uses a user token | Worked out for the record on screen |
| Example | Overdue customer entries; my open sales orders | Open orders for this customer on the customer card |
| Filter tokens | Dates and users | Dates, users and {Rec.Field} |
| Calculated | In the background, then cached | Live, every time, never cached |
| Used by | Cues, FactBoxes, Alerts (total rules), Notifications, Trends | FactBoxes, Notifications (on pages), Alerts (record rules) |
To make a Per Record measure, set its Record Table, then use {Rec.FieldName} tokens in the filter to refer to the record on screen:
Document Type=Order;Sell-to Customer No.={Rec.No.}With Record Table 18 Customer, this counts the open sales orders for whichever customer is being viewed. Show Record Table Fields lists the field names you can use. Preview Value and Show Records use the first record in the Record Table.
Measures in use are protected: their type and Record Table stay fixed while a product relies on them, so nothing breaks unexpectedly.
Built for speed
Section titled “Built for speed”- Count, Sum and Average run as a single database query, so they stay quick even on large ledgers.
- Min, Max and FlowField totals read only the one field they need, and work best on a focused set of records, such as open entries or this month.
- Role centre values are worked out in the background and cached, so role centres open quickly however many tiles you add.
Built to be safe
Section titled “Built to be safe”- Clear feedback, no broken pages. If a measure can’t be worked out, for example after a filter is mistyped, tiles show a neutral value instead of an error, and Preview Value and Dynamic Measure Cache tell you exactly why.
- Protected while in use. A measure that a tile, rule, notification or trend relies on can’t be deleted by accident.