frame

frame, tile type

The frame tile displays a table-like block. Declare ordinary column expressions directly inside with, without a columns block. A bar block displays a numeric expression as a horizontal bar in each row.

Examples

Each expression below produces a column:

table T = with
  [| as Name, as Qty |]
  [| "A", 10 |]
  [| "B", 5 |]

show frame "Items" { 1..6, 1..8 } with
  T.Name
  T.Qty

For numeric comparisons, a bar block contains one numeric expression. Here, the bars compare stock surpluses and shortages against a target:

table T = with
  [| as Item, as OnHand, as Target |]
  [| "A", 30, 20 |]
  [| "B", 5, 20 |]
  [| "C", 20, 20 |]

show frame "Stock gaps" { 1..6, 1..8 } with
  T.Item
  bar
    T.OnHand - T.Target { color: blue }

The gaps are 10, -15, and 0. Positive bars extend to the right of zero; negative bars extend to the left.