// Example: assert
myAssertion = false
{ backgroundColor: tomato }
show assert "My Assert" a1b1 with
myAssertion
// Example: barchart
table Items = with
[| as SKU, as Category, as Quantity |]
[| "AAA", "CAT_1", 10 |]
[| "BBB", "CAT_2", 20 |]
[| "CCC", "CAT_1", 30 |]
{ backgroundColor: tomato }
show barchart "My BarChart" a1b6 with
sum(Items.Quantity)
group by Items.Category
// Example: form
read form with
SKU: text
Maximum: number
{ backgroundColor: tomato }
show form "My Form" a1b1 with
SKU
Maximum
// Example: gauge
{ backgroundColor: tomato }
show gauge "My gauge" a1b2 with 0.5
// Example: histogram
table T = extend.range(1000)
T.X = random.poisson(5 into T)
{ backgroundColor: tomato }
show histogram "My histogram" a1f4 with T.X
// Example: label
{ backgroundColor: tomato }
show label "My Label" a1b1
// 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 |]
{ backgroundColor: tomato }
show linechart "My Line Chart" a1b6 with
Day.StockOnHand
Day.StockOnOrder
// Example: logo
{ backgroundColor: tomato }
show logo "" a1b3
// Example: markdown
{ backgroundColor: tomato }
show markdown "My Markdown" a1b3 with """Some markdown text"""
// Example: menu
{ backgroundColor: tomato }
show menu "" a1b3 with
"Section"
// Example: piechart
table Sales = with
[| as Quantity, as Category |]
[| 10, "A" |]
[| 1, "B" |]
[| 5, "B" |]
[| 4, "A" |]
[| 12, "C" |]
{ backgroundColor: tomato }
show piechart "My Pie Chart" a1b6 with
sum(Sales.Quantity)
group by Sales.Category
// Example: plot
table Sales = with
[| as Quantity, as Discount |]
[| 10, 40 |]
[| 2, 10 |]
[| 1, 0 |]
{ backgroundColor: tomato }
show plot "My Plot" a1d4 with
Sales.Quantity
Sales.Discount
// Example: scalar
myValue = 123
{ backgroundColor: tomato }
show scalar "My Scalar" a1b1 with
myValue
// Example: scatter
table Sales = with
[| as Quantity, as Discount |]
[| 10, 40 |]
[| 2, 10 |]
[| 1, 0 |]
{ backgroundColor: tomato }
show scatter "My Scatter Plot" a1d4 with
Sales.Quantity
Sales.Discount
// Example: slicepicker
table Items = with
[| as Id |]
[| "A" |]
[| "B" |]
[| "C" |]
Items.Slice = sliceDashboard(Items.Id) by Items.Id
{ backgroundColor: tomato }
show slicepicker "Pick a slice" a1b3 with
same(Items.Id)
// Example: slicetree
table Items = with
[| as Id |]
[| "A" |]
[| "B" |]
[| "C" |]
Items.Slice = sliceDashboard(Items.Id) by Items.Id
{ backgroundColor: tomato }
show slicetree "Pick a slice" a1b3 with
same(Items.Id)
// Example: summary
table Sales = with
[| as Quantity, as NetAmount |]
[| 10, 40 |]
[| 2, 10 |]
[| 1, 20 |]
{ backgroundColor: tomato }
show summary "My Summary" a1b3 with
sum(Sales.Quantity)
sum(Sales.NetAmount)
// Example: table
table Orders = with
[| as Date, as Quantity |]
[| date(2023,02,21), 150 |]
[| date(2023,02,22), 250 |]
{ backgroundColor: tomato }
show table "My Table" a1c4 with
Orders.Date
Orders.Quantity
// Example: tabs
{ backgroundColor: tomato }
show tabs "My Tabs" a1b3 with
"tab1"
"tab2"
// Example: tabs > tab > badge
show tabs "My Tabs" a1b3 with
"tab1" { badge { backgroundColor: tomato } }
"tab2"
// Example: treemap
table T = with
[| as Quantity, as Label |]
[| 10, "A" |]
[| 1, "B" |]
[| 5, "B" |]
[| 4, "A" |]
[| 12, "C" |]
{ backgroundColor: tomato }
show treemap "My Treemap" a1b6 with
sum(T.Quantity)
T.Label
group by T.Label
// Example: upload
read upload "customsuppliers" as MySuppliers with
SupplierId : text
SupplierQuota : number
SupplierCountry : text
{ backgroundColor: tomato }
show upload "My Upload" a1b1 editable:"customsuppliers"