// Example: barchart > haxis
table Items = with
[| as SKU, as Category, as Quantity |]
[| "AAA", "CAT_1", 10 |]
[| "BBB", "CAT_2", 20 |]
[| "CCC", "CAT_1", 30 |]
{ haxis { axisMin: -100 } }
show barchart "My BarChart" a1b6 with
sum(Items.Quantity)
group by Items.Category
// Example: barchart > vaxis > left
table Items = with
[| as SKU, as Category, as Quantity |]
[| "AAA", "CAT_1", 10 |]
[| "BBB", "CAT_2", 20 |]
[| "CCC", "CAT_1", 30 |]
{ vaxis { left { axisMin: -100 } } }
show barchart "My BarChart" a1b6 with
sum(Items.Quantity)
group by Items.Category
// Example: barchart > vaxis > right
table Items = with
[| as SKU, as Category, as Quantity |]
[| "AAA", "CAT_1", 10 |]
[| "BBB", "CAT_2", 20 |]
[| "CCC", "CAT_1", 30 |]
{ vaxis { right { axisMin: -100 } } }
show barchart "My BarChart" a1b6 with
sum(Items.Quantity)
group by Items.Category
// Example: histogram > haxis
table T = extend.range(1000)
T.X = random.poisson(5 into T)
{ haxis { axisMin: -100 } }
show histogram "My histogram" a1f4 with T.X
// Example: linechart > haxis
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 |]
{ haxis { axisMin: -100 } }
show linechart "My Line Chart" a1b6 with
Day.StockOnHand
Day.StockOnOrder
// 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 |]
{ vaxis { left { axisMin: -100 } } }
show linechart "My Line Chart" a1b6 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 |]
{ vaxis { right { axisMin: -100 } } }
show linechart "My Line Chart" a1b6 with
Day.StockOnHand
Day.StockOnOrder
// Example: plot > haxis
table Sales = with
[| as Quantity, as Discount |]
[| 10, 40 |]
[| 2, 10 |]
[| 1, 0 |]
show plot "My Plot" a1d4 with
Sales.Quantity { axisMin: -100 }
Sales.Discount
// Example: plot > vaxis
table Sales = with
[| as Quantity, as Discount |]
[| 10, 40 |]
[| 2, 10 |]
[| 1, 0 |]
{ vaxis { axisMin: -100 } }
show plot "My Plot" a1d4 with
Sales.Quantity
Sales.Discount
// Example: scatter > haxis
table Sales = with
[| as Quantity, as Discount |]
[| 10, 40 |]
[| 2, 10 |]
[| 1, 0 |]
show scatter "My Scatter Plot" a1d4 with
Sales.Quantity { axisMin: -100 }
Sales.Discount
// Example: scatter > vaxis
table Sales = with
[| as Quantity, as Discount |]
[| 10, 40 |]
[| 2, 10 |]
[| 1, 0 |]
{ vaxis { axisMin: -100 } }
show scatter "My Scatter Plot" a1d4 with
Sales.Quantity
Sales.Discount
Details
A value of min indicates that the lowest value min(values) should be used. The considered values include areaTo or the consequence of stacking bars with a stackseriesType. For the horizontal axis of a linechart, this will be the earliest date for which a value is provided (even if that value is zero).
A value of auto is usually the same as min(values), except:
For a numerical axis, if min(values) > 0 and max(values) - min(values) > 0.25 * max(values), auto will set it to 0 instead.
For a linechart horizontal axis, auto will use the first date associated with at least one non-zero value.
An explicit value just uses that minimum. However, if an explicit numerical value is provided that is above min(values) (which would cause some values to be outside the range), it is replaced with min(values) so that all values remain in the range (this is not the case for date values).