🚧 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.
fractionSeparator
Specifies the separator between integer and fractional digits in the number pipeline.
// 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 { fractionSeparator: "," } }
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 { fractionSeparator: "," }
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 { fractionSeparator: "," } } } 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 { fractionSeparator: "," } } } 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 { fractionSeparator: "," } }
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 { fractionSeparator: "," } }
// 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 { fractionSeparator: "," }
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 { fractionSeparator: "," } }
// Example: gauge > entry > value
show gauge "My Gauge" { 1..3, 1..4 } with 0.5 { value { fractionSeparator: "," } }
// 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 { fractionSeparator: "," } } } 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 { fractionSeparator: "," } } } 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 { fractionSeparator: "," } }
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 { fractionSeparator: "," } }
group by Sales.Category
// Example: scalar > entry > value
myValue = 123
show scalar "My Scalar" { 1..2, 1..2 } with
myValue { value { fractionSeparator: "," } }
// 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 { fractionSeparator: "," } }
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 { fractionSeparator: "," } }
Orders.Quantity