Navigation :

StyleCode Property: dateFormat 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.

dateFormat

Specifies the format used to print out dates.

Applies to	Type	Default
`chart > haxis` `frame > column > entry > value` `frame > columns > column > value` `linechart > haxis > value` `scalar > entry > value` `summary > entry > value` `table > column > value`	dayFormat	`default`

Examples

// 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 { dateFormat: "ddd MMM d, yyyy" }
  plot by T.X
    same(T.Y)

// Example: linechart > haxis > value
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 ; haxis { value { dateFormat: "ddd MMM d, yyyy" } } } with
  Day.StockOnHand
  Day.StockOnOrder

// Example: scalar > entry > value
myValue = 123

show scalar "My Scalar" { 1..2, 1..2 } with
  myValue { value { dateFormat: "ddd MMM d, yyyy" } }

// 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 { dateFormat: "ddd MMM d, yyyy" } }
  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 { dateFormat: "ddd MMM d, yyyy" } }
  Orders.Quantity

User Contributed Notes

0 notes + add a note