d3.js 格式化超集/ Caravel数据透视表中的指标

i7uaboj4 于 2022-11-12 发布在其他

关注(0)|答案(3)|浏览(133)

我的Superset / Caravel数据透视表切片以科学记数法显示指标（在本例中为收入总和）。

All 4.136578e+08    355190412.0 5.375492e+07    8.226031e+08

我如何用千位分隔符很好地显示它？
我找不到任何选项来为数据透视表可视化类型指定数字格式。相反，当我使用大数字类型创建切片时，有一个选项可以指定数字格式，它接受D3数字格式。我找不到数据透视表的此选项。

d3.js

来源：https://stackoverflow.com/questions/41100449/formatting-metrics-in-superset-caravel-pivot-table

3条答案

按热度按时间

gpnt7bae1#

您可以通过以下方式更改它：-选择表。编辑记录。列出sql指标。然后选择指标。您可以用+，|+12，345.4321美元

赞(0）回复(0）举报 2022-11-12

fcg9iug32#

您可以更改D3格式中的编号，以下是一些指南：

{
  "decimal": ".",
  "thousands": ",",
  "grouping": [3],
  "currency": ["$", ""],
  "dateTime": "%a %b %e %X %Y",
  "date": "%m/%d/%Y",
  "time": "%H:%M:%S",
  "periods": ["AM", "PM"],
  "days": ["Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday"],
  "shortDays": ["Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat"],
  "months": ["January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December"],
  "shortMonths": ["Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"]
}

赞(0）回复(0）举报 2022-11-12

brccelvz3#

它可以在数据集编辑面板中定义，如下所示：