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