ec.clmn: Data column format

ec.clmnR Documentation

Data column format


Helper function to display/format data column(s) by index or name


ec.clmn(col = NULL, ..., scale = 1)



A single column index(number) or column name(quoted string),
or a sprintf format string. Or 'log' for debugging. Default is NULL, for charts with single values like tree, pie.
'json' - display tooltip with all available values to choose from
'log' will write all values in the JS console (F12)


A comma separated column indexes or names, only when col is sprintf. This allows formatting of multiple columns, as for a tooltip.


A positive number, multiplier for numeric columns. When scale is 0, all numeric values are rounded.


This function is useful for attributes like formatter, color, symbolSize.
Column indexes are counted in R and start at 1.
Omit col or use index -1 for single values in tree/pie charts, axisLabel.formatter or valueFormatter. See dendrogram example.
Use only column indexes when setting symbolSize.
Column indexes are decimals for combo charts with multiple series, see example. The whole number part is the serie index, the decimal part is the column index inside.
col as sprintf has the same placeholder %@ for both column indexes or column names.
col as sprintf can contain double quotes, but not single or backquotes.

  • %L@ will display a number in locale format, like '12,345.09'.

  • %LR@ rounded number in locale format, like '12,345'.

  • %R@ rounded number, like '12345'.

  • %M@ marker in serie's color.


A JavaScript code string (usually a function) marked as executable, see JS.


tmp <- data.frame(Species = as.vector(unique(iris$Species)),
                  emoji = c('\U0001F33B','\U0001F335','\U0001F33A'))
df <- iris |> dplyr::inner_join(tmp)      # add 6th column emoji
df |> dplyr::group_by(Species) |> ec.init() |> ec.upd({
  series <- lapply(series,
    function(s) append(s,
      list(label= list(show= TRUE, formatter= ec.clmn('emoji')))) )
  tooltip <- list(formatter=
    # ec.clmn with sprintf + multiple column indexes
    ec.clmn('%M@ species <b>%@</b><br>s.len <b>%@</b><br>s.wid <b>%@</b>', 5,1,2))

echarty documentation built on Nov. 24, 2022, 5:06 p.m.

Related to ec.clmn in echarty...