// 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 { axisMax: 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 { axisMax: 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 { axisMax: 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 { axisMax: 100 } }
show histogram "My histogram" a1f4 with T.X
// Example: histogram > vaxis
table T = extend.range(1000)
T.X = random.poisson(5 into T)
{ vaxis { axisMax: 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 { axisMax: 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 { axisMax: 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 { axisMax: 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 { axisMax: 100 }
Sales.Discount
// Example: plot > vaxis
table Sales = with
[| as Quantity, as Discount |]
[| 10, 40 |]
[| 2, 10 |]
[| 1, 0 |]
{ vaxis { axisMax: 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 { axisMax: 100 }
Sales.Discount
// Example: scatter > vaxis
table Sales = with
[| as Quantity, as Discount |]
[| 10, 40 |]
[| 2, 10 |]
[| 1, 0 |]
{ vaxis { axisMax: 100 } }
show scatter "My Scatter Plot" a1d4 with
Sales.Quantity
Sales.Discount
Details
A value of max indicates that the lowest value max(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 latest 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 max(values) < 0 and min(values) - max(values) < 0.25 * min(values), auto will set it to 0 instead.
For a linechart horizontal axis, auto will use the last date associated with at least one non-zero value.
An explicit value just uses that maximum. However, if an explicit numerical value is provided that is below max(values) (which would cause some values to be outside the range), it is replaced with max(values) so that all values remain in the range (this is not the case for date values).