🚧 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.
// Example: barchart > series
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 } with
sum(Items.Quantity) { textColor: "#FF6347" }
group by Items.Category
// Example: barchart > series > value
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 } with
sum(Items.Quantity) { value { textColor: "#FF6347" } }
group by Items.Category
// Example: gauge
show gauge "My Gauge" { 1..3, 1..4 ; textColor: "#FF6347" } with 0.5
// Example: label
show label "My Label" { 1..2, 1..2 ; textColor: "#FF6347" }
// Example: markdown
show markdown "My Markdown" { 1..3, 1..3 ; textColor: "#FF6347" } with """Some markdown text"""
// Example: scalar
myValue = 123
show scalar "My Scalar" { 1..2, 1..2 ; textColor: "#FF6347" } with
myValue
// Example: scalar > entry > value
myValue = 123
show scalar "My Scalar" { 1..2, 1..2 } with
myValue { value { textColor: "#FF6347" } }
// Example: summary > entry > value
table Sales = with
[| as Quantity, as NetAmount |]
[| 10, 40 |]
[| 2, 10 |]
[| 1, 20 |]
show summary "My Summary" { 1..3, 1..3 } with
sum(Sales.Quantity) { value { textColor: "#FF6347" } }
sum(Sales.NetAmount)
// Example: table > column > append
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 } with
Orders.Date { append { textColor: "#FF6347" } }
Orders.Quantity
// Example: table > column > prepend
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 } with
Orders.Date { prepend { textColor: "#FF6347" } }
Orders.Quantity
// Example: table > column > value
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 } with
Orders.Date { value { textColor: "#FF6347" } }
Orders.Quantity