Function formatValue

server/charts/TableView.js:7–41

(value, config, timezone)

const checkNumbersOnly = /^\d+$/;

function formatValue(value, config, timezone) {
  if (!config || !config.type || !value) return value;

  if (config.type === "date" && determineType(value) === "date" && config.format) {
    const isTimestamp = value.toString().length === 10 && `${value}`.match(checkNumbersOnly);
    const momentObj = isTimestamp ? moment.utc(value, "X") : moment.utc(value);
    return timezone
      ? momentObj.tz(timezone).format(config.format)
      : momentObj.format(config.format);
  } else if ((config.type === "number" || config.type === "currency")
    && (determineType(value) === "number" || `${value}`.match(checkNumbersOnly))
  ) {
    let finalNumber = value;
    if (config.decimals > -1) {
      finalNumber = Number(value).toFixed(config.decimals);
    }
    if (config.thousandsSeparator) {
      finalNumber = finalNumber.toString().replace(/\B(?=(\d{3})+(?!\d))/g, ",");
    }
    if (config.type === "currency" && config.symbol) {
      finalNumber = `${config.symbol}${finalNumber}`;
    }
    return finalNumber;
  }

  // value mapping
  if (config.display?.format === "mapping" && config.display?.rules) {
    const rule = config.display.rules.find((rule) => rule.value === value);
    if (rule) {
      return rule.label;
    }
  }

  return value;
}

class TableView {
  getTableData(data, chartData, timezone = "") {