- 新しい順
- 投票が多い順
- コメントが多い順
As per SPICE Limitaion, "QuickSight enables you to create calculations that are based on DECIMAL data having more than four decimal places to the right of the decimal point. However, QuickSight can display no more than four decimal places to the right of the decimal point. The value is truncated, not rounded, when displayed in data preparation or analyses and when imported into SPICE."
[+] Supported data types and values - Numeric data - https://docs.aws.amazon.com/quicksight/latest/user/supported-data-types-and-values.html#numeric
One workaround for the issue is to use the formula :
(sum(cost^1)/sum(cost2^1))*10000
Which basically puts a dummy power function on the column, whose result is Double type.
Please try the above and let me know if it helps. Thank you!
関連するコンテンツ
- AWS公式更新しました 2年前
- AWS公式更新しました 2年前