Wrong Data Format

Question & Answer
, ,
1

The CXO ARK Scan Compliance report contains an error in the data type formatting for the RMA ID column. It should be designated as a text field.

2

Hi @hsjesula

Welcome to the QuickSight community!

You can easily easily correct the data type for this column to String/Text.

To make this change, you can:

  • Edit the Dataset used in the report.
  • Locate the RMA ID column.
  • Change the data type to Text/String.
  • Save/Publish the changes and refresh the analysis to apply the updated format.
1 Like
3

Thanks for your soon reply, that’s what I do every time that I need to read the data, is there anyway to have the data on the right format? without us to modify it? it should be just formatted as text.

4

Hi @hsjesula

When QuickSight retrieves data, it assigns each field a data type based on the data in the field. If you want to change datatype of field you need to edit the dataset and change the data type.

Please refer to the below documentation this might be helpful for you.