AWS announces AWS Interconnect – multicloud (preview), providing simple, resilient, high-speed private connections to other cloud service providers. AWS Interconnect - multicloud is easy to configure and provides high-speed, resilient connectivity with dedicated bandwidth, enabling customers to interconnect AWS networking services such as AWS Transit Gateway, AWS Cloud WAN, and Amazon VPC to other cloud service providers with ease.
Complete or part of text field converted to scientific notation in Quicksight
I'm trying to display a text field that's a concatenation of 2 letters and about 20 digits. The column is formatted as text.
In the screenshot, the value is visible without issue in the "COLUMN A VALUE" visual, that's a wordcloud.
In the table visual, a section of the digits is converted to scientific notation, see "COLUMN A". When trying to display a field composed only of the problematic digit section formatted as text, the scientific notation appears again, see "COLUMN B".
As a workaround I have trying splitting the value with whitespaces or dashes, however even with these separators the scientific notation persists.
This text value needs to be displayed as is, without any scientific notation.
- 新しい順
- 投票が多い順
- コメントが多い順
Hello JBW, Thank you very much for your question. If your text field in AWS QuickSight is being converted to scientific notation, it usually happens when numbers in the text field are interpreted as numeric data. To prevent this, you can ensure that the data type for your field is set to string in the data preparation stage or during dataset creation.
- Change Data Type to String: Make sure the field's data type is explicitly set to string in the dataset.
- Custom Format: Use custom formatting options in QuickSight to prevent automatic conversion.
Please find further resources by accessing these links: https://docs.aws.amazon.com/quicksight/latest/user/supported-data-types-and-values.html https://docs.aws.amazon.com/quicksight/latest/user/changing-a-field-data-type.html https://docs.aws.amazon.com/quicksight/latest/user/toString-function.html
