How to load long decimal data (> 10 digit) in quick sight

[sbaskax]

Hi All,

My input value is 0.000001234 but after loading this data in dataset it is getting truncated as 0.0 due to this visualization is showing wrong figures, how to over come this

[Max]

I would look into this.

Quicksight - Rounding to 2 decimals

I only use direct SPICE import for analysis, as direct import isn’t allowed due to privacy concerns. I was able to just use multiplication by 100.0000 with number format and it works fine. Though, I do hope the feature is released soon.

You might also look to multiply by 1000 or so in sql and then divide them again by 1000 in a calculated field in quicksight.

[sbaskax]

Thank you Max, will try this