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.

1 Like
5

However, it would be helpful if we had the right data, which we currently lack due to an incorrect original field definition. Perhaps the developer who generated the report isn’t aware of this. Is there a way to inform them?

This would ensure we have accurate information and reduce manual processes that can lead to errors.

6

Hi @hsjesula

Please check with your organization’s QuickSight admin to identify the owner of the dataset so they can be notified to correct it. Otherwise, you will need to gain access to the dataset to change the datatype.

7

Hi @hsjesula

It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.

If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.

Thank you!

8

Hi @hsjesula

Since we have not heard back from you, I’ll go ahead and close this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!