🚧 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 > 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 { unitPosition: "right" } }
group by Items.Category
// Example: chart > haxis
table T = extend.range(5)
T.X = T.N
T.Y = T.N * 2
show chart "My Chart" { 1..6, 1..6 } with
haxis by T.X { unitPosition: "right" }
plot by T.X
same(T.Y)
// Example: chart > vaxis > left
table T = extend.range(5)
T.X = T.N
T.Y = T.N * 2
show chart "My Chart" { 1..6, 1..6 ; vaxis { left { unitPosition: "right" } } } with
haxis by T.X
plot by T.X
same(T.Y)
// Example: chart > vaxis > right
table T = extend.range(5)
T.X = T.N
T.Y = T.N * 2
show chart "My Chart" { 1..6, 1..6 ; vaxis { right { unitPosition: "right" } } } with
haxis by T.X
plot by T.X
same(T.Y)
// Example: chart > plotxy > series > value
table T = extend.range(5)
T.X = T.N
T.Y = T.N * 2
show chart "My Chart" { 1..6, 1..6 } with
plotxy T.X
T.Y { value { unitPosition: "right" } }
order by T.Y
// Example: chart > plot > series > line > value
table T = extend.range(5)
T.X = T.N
T.Y = T.N * 2
show chart "My Chart" { 1..6, 1..6 } with
haxis by T.X
plot by T.X
same(T.Y) { value { unitPosition: "right" } }
// Example: chart > haxis
table T = extend.range(5)
T.X = T.N
T.Y = T.N * 2
show chart "My Chart" { 1..6, 1..6 } with
haxis by T.X { unitPosition: "right" }
plot by T.X
same(T.Y)
// Example: chart > scatter > series > value
table T = extend.range(5)
T.X = T.N
T.Y = T.N * 2
show chart "My Chart" { 1..6, 1..6 } with
scatter T.X
T.Y { value { unitPosition: "right" } }
// Example: gauge > entry > value
show gauge "My Gauge" { 1..3, 1..4 } with 0.5 { value { unitPosition: "right" } }
// Example: linechart > vaxis > left
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 ; vaxis { left { unitPosition: "right" } } } with
Day.StockOnHand
Day.StockOnOrder
// Example: linechart > vaxis > right
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 ; vaxis { right { unitPosition: "right" } } } with
Day.StockOnHand
Day.StockOnOrder
// Example: linechart > series > line > value
table T[Date] = with
[| as Date, as Value |]
[| date(2023,01,15), 15 |]
[| date(2023,01,16), 5 |]
[| date(2023,01,17), 12 |]
show linechart "My Line Chart" { 1..4, 1..6 } with
same(T.Value) { value { unitPosition: "right" } }
group by T.Date
// Example: piechart > series > value
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 } with
sum(Sales.Quantity) { value { unitPosition: "right" } }
group by Sales.Category
// Example: scalar > entry > value
myValue = 123
show scalar "My Scalar" { 1..2, 1..2 } with
myValue { value { unitPosition: "right" } }
// 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 { unitPosition: "right" } }
sum(Sales.NetAmount)
// 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 { unitPosition: "right" } }
Orders.Quantity