StyleCode Property: unit v2
🚧 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.
unit
Controls the unit of numbers in the number pipeline.
Examples
// 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 { unit: "$" } }
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 { unit: "$" }
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 { unit: "$" } } } 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 { unit: "$" } } } with
haxis by T.X
plot by T.X
same(T.Y)
// Example: chart > plotxy > series
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 { unit: "$" }
order by 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 { unit: "$" } }
order by T.Y
// Example: chart > plot > series > line
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) { seriesType: line ; unit: "$" }
// 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 { unit: "$" } }
// Example: chart > plot > series > stack
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) { seriesType: stack ; unit: "$" }
// Example: chart > plot > series > bar
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) { seriesType: bar ; unit: "$" }
// Example: chart > plot > series > area
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) { seriesType: area ; unit: "$" }
// Example: chart > plot > series > background
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) { seriesType: background ; unit: "$" }
// Example: chart > plot > series > box
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) { seriesType: box ; unit: "$" }
// 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 { unit: "$" }
plot by T.X
same(T.Y)
// Example: chart > scatter > series
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 { unit: "$" }
// 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 { unit: "$" } }
// Example: gauge > entry > value
show gauge "My Gauge" { 1..3, 1..4 } with 0.5 { value { unit: "$" } }
// 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 { unit: "$" } } } 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 { unit: "$" } } } with
Day.StockOnHand
Day.StockOnOrder
// Example: linechart > series > line
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) { seriesType: line ; unit: "$" }
group by T.Date
// 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 { unit: "$" } }
group by T.Date
// Example: linechart > series > stack
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) { seriesType: stack ; unit: "$" }
group by T.Date
// Example: linechart > series > bar
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) { seriesType: bar ; unit: "$" }
group by T.Date
// Example: linechart > series > area
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) { seriesType: area ; unit: "$" }
group by T.Date
// Example: linechart > series > background
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) { seriesType: background ; unit: "$" }
group by T.Date
// Example: linechart > series > box
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) { seriesType: box ; unit: "$" }
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 { unit: "$" } }
group by Sales.Category
// Example: scalar > entry > value
myValue = 123
show scalar "My Scalar" { 1..2, 1..2 } with
myValue { value { unit: "$" } }
// 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 { unit: "$" } }
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 { unit: "$" } }
Orders.Quantity