🚧 Work in progress — This documents the redesigned dashboard layout system, which is still under active development and subject to change. It is not compatible with the older v1 dashboard tile system.
tileZoom
Allow the tile to be clicked on (if contextually relevant) to have a full window version inside a modal.
// Example: barchart
table Items = with
[| as SKU, as Category, as Quantity |]
[| "AAA", "CAT_1", 10 |]
[| "BBB", "CAT_2", 20 |]
[| "CCC", "CAT_1", 30 |]
show barchart "My BarChart" { 1..4, 1..6 ; tileZoom: False } with
sum(Items.Quantity)
group by Items.Category
// Example: frame
table Orders = with
[| as Date, as Quantity |]
[| date(2023,02,21), 150 |]
[| date(2023,02,22), 250 |]
show frame "My Frame" { 1..3, 1..10 ; tileZoom: False } with
columns
Orders.Date
Orders.Quantity
// Example: linechart
table Day[Date] = with
[| as Date, as StockOnHand, as StockOnOrder |]
[| date(2023,01,15), 15,10 |]
[| date(2023,01,16), 5, 2 |]
[| date(2023,01,17), 12, 4 |]
[| date(2023,01,18), 13, 7 |]
show linechart "My Line Chart" { 1..4, 1..6 ; tileZoom: False } with
Day.StockOnHand
Day.StockOnOrder
// Example: markdown
show markdown "My Markdown" { 1..3, 1..3 ; tileZoom: False } with """Some markdown text"""
// Example: piechart
table Sales = with
[| as Quantity, as Category |]
[| 10, "A" |]
[| 1, "B" |]
[| 5, "B" |]
[| 4, "A" |]
[| 12, "C" |]
show piechart "My Pie Chart" { 1..4, 1..6 ; tileZoom: False } with
sum(Sales.Quantity)
group by Sales.Category
// Example: summary
table Sales = with
[| as Quantity, as NetAmount |]
[| 10, 40 |]
[| 2, 10 |]
[| 1, 20 |]
show summary "My Summary" { 1..3, 1..3 ; tileZoom: False } with
sum(Sales.Quantity)
sum(Sales.NetAmount)
// Example: table
table Orders = with
[| as Date, as Quantity |]
[| date(2023,02,21), 150 |]
[| date(2023,02,22), 250 |]
show table "My Table" { 1..4, 1..4 ; tileZoom: False } with
Orders.Date
Orders.Quantity