- Le plus récent
- Le plus de votes
- La plupart des commentaires
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!
Contenus pertinents
- demandé il y a un an
- demandé il y a 2 mois
- demandé il y a un an
- AWS OFFICIELA mis à jour il y a 2 ans