# Datos incorrectos

**URL:** <https://community.amazonquick.com/t/datos-incorrectos/28834>\
**Category:** Q&A\
**Tags:** error, developer, quick-sight\
**Created:** [April 19, 2024, 1:50am UTC](https://community.amazonquick.com/t/datos-incorrectos/28834 "2024-04-19T01:50:16Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![Santi98](https://avatars.discourse-cdn.com/v4/letter/s/e0b2c6/32.png) [@Santi98](https://community.amazonquick.com/u/Santi98)\
**Post date:** [April 19, 2024, 1:50am UTC](https://community.amazonquick.com/t/datos-incorrectos/28834/1 "2024-04-19T01:50:17Z")

</div>

Hola a todos,

Tengo el siguiente problema, estoy cargando un DS desde una BD pero cuando observo los datos en QS son diferentes pareciera como si se movieran algunos incluso de fecha, por ejemplo:  
 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/b/8/b85098848241377eed8fb34bc5a20c8e7cccf819.png)  
y en la BD están así  
 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/1/8/1831134e6505e218824878ff99345bbd8fcffa16.png)  
No se que pasa que QS esta cambiando los datos

---

<div class="post-metadata">

**Author:** ![andres007](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/andres007/32/8734_2.png) [@andres007](https://community.amazonquick.com/u/andres007)\
**Post date:** [April 22, 2024, 9:19am UTC](https://community.amazonquick.com/t/datos-incorrectos/28834/2 "2024-04-22T09:19:35Z")

</div>

Hi @Santi98,

I do not see a correlation between the 2 screenshots, I could not find any of the date/times in any of those, so I see no pattern to identify where to help you.

It is possible that you are finding differences related to dates if the dates you are entering are taking in consideration the timezone, but without access to the dataset and database itself it is hard to identify what is happening.

Maybe some of these links will help you with the troubleshooting.

> **[Customize date and time values of an analysis - Amazon QuickSight](https://docs.aws.amazon.com/quicksight/latest/user/analysis-date-time.html)**
>
> Use this section to learn more about the custom date and time settings of an Amazon QuickSight analysis.

> [@Converting dates and timestamp fields in QuickSight](https://community.amazonquick.com/t/converting-dates-and-timestamp-fields-in-quicksight/10006):
>
> Date and timestamp fields can be represented in a seemingly endless number of formats. Many of these are automictically recognised by QuickSight, but if your date and timestamp fields use some of the more complex or non-standard formats you will need to convert them in QuickSight while preparing your dataset to a [Date datatype](https://docs.aws.amazon.com/quicksight/latest/user/supported-data-types-and-values.html) (which can include either dates or dates plus times). Using the [supported](https://docs.aws.amazon.com/quicksight/latest/user/supported-date-formats.html) date formats you can easily convert these timestamp “strings” into a supported datatype by usin…

Hope this helps! And if you have any additional information to help us please post it here so we can keep digging together!

Kind regards,  
Andres.

---

<div class="post-metadata">

**Author:** ![Santi98](https://avatars.discourse-cdn.com/v4/letter/s/e0b2c6/32.png) [@Santi98](https://community.amazonquick.com/u/Santi98)\
**Post date:** [April 22, 2024, 9:57pm UTC](https://community.amazonquick.com/t/datos-incorrectos/28834/3 "2024-04-22T21:57:40Z")

</div>

Hola! @andres007

Precisamente ese es mi problema desde la base de datos que es la segunda imagen solo extraje las fechas sin las horas, y el ultimo campo de la primera imagen que es en QS no concuerda con el ultimo campo de la segunda imagen y supuestamente son las mismas fechas.

---

<div class="post-metadata">

**Author:** ![andres007](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/andres007/32/8734_2.png) [@andres007](https://community.amazonquick.com/u/andres007)\
**Post date:** [April 23, 2024, 6:38am UTC](https://community.amazonquick.com/t/datos-incorrectos/28834/4 "2024-04-23T06:38:48Z")

</div>

What is very strange is that there is no pattern between the dates and the times, not even with some hours of difference to point us in any direction. I cannot actually see that the screenshot of the DB is related to the one on top since I cannot see the name/email in the DB one. Having a key in the DB to match to the Quick Sight table might give us some hints of what is happening and if we are looking at the same data.

---

<div class="post-metadata">

**Author:** ![Santi98](https://avatars.discourse-cdn.com/v4/letter/s/e0b2c6/32.png) [@Santi98](https://community.amazonquick.com/u/Santi98)\
**Post date:** [April 25, 2024, 2:45pm UTC](https://community.amazonquick.com/t/datos-incorrectos/28834/5 "2024-04-25T14:45:52Z")

</div>

Hola @andres007 te comparto las imágenes de nuevo

Base de datos

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/0/8/0852555fc5f27bd11a3cbcd6f032ec2b74aa53c1.png)

QS  
 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/1/e/1e961741a09add6620bdc0f04c696a0628f0551a.png)

Además de que se mueven los datos hay uno que no aparece, desde donde estos haciendo la consulta es zonas horaria -0500 Colombia, intente cambiarlo desde el editor de UTC de QS pero no funciono, no se que es lo que pasa que los datos se me están moviendo y algunos no aparecen. Este ejemplo es de una persona pero así esta toda la data cuando se carga en QS

---

<div class="post-metadata">

**Author:** ![andres007](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/andres007/32/8734_2.png) [@andres007](https://community.amazonquick.com/u/andres007)\
**Post date:** [April 26, 2024, 11:11am UTC](https://community.amazonquick.com/t/datos-incorrectos/28834/6 "2024-04-26T11:11:45Z")

</div>

The only thing that makes sense to me is that because of the TZ, as you are confirming, some of the entries are moving to another UTC date.

I can try to reproduce this, but another option I am thinking is that you send the date without a timezone to QS and see if you can get the data at least to stay in the same date. Then you can add the offset of time, if you want with calculated fields.

---

<div class="post-metadata">

**Author:** ![Santi98](https://avatars.discourse-cdn.com/v4/letter/s/e0b2c6/32.png) [@Santi98](https://community.amazonquick.com/u/Santi98)\
**Post date:** [April 26, 2024, 4:09pm UTC](https://community.amazonquick.com/t/datos-incorrectos/28834/7 "2024-04-26T16:09:45Z")

</div>

@andres007 Ya intente subiendo solo el DS con las fechas, sin ninguna marca de tiempo, y modifique la zona horaria desde QS pero aun así los datos siguen sin estar bien.

Que campo calculado aplicaria?

---

<div class="post-metadata">

**Author:** ![andres007](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/andres007/32/8734_2.png) [@andres007](https://community.amazonquick.com/u/andres007)\
**Post date:** [April 29, 2024, 6:38am UTC](https://community.amazonquick.com/t/datos-incorrectos/28834/8 "2024-04-29T06:38:19Z")

</div>

I was thinking on using addDateTime to the end value after you loaded the data without a TZ to make it colombian time off course that is not what should be done.

> **[addDateTime - Amazon QuickSight](https://docs.aws.amazon.com/quicksight/latest/user/addDateTime-function.html)**
>
> addDateTime adds or subtracts a unit of time from a datetime value. For example, addDateTime(2,'YYYY',parseDate('02-JUL-2018', 'dd-MMM-yyyy') ) returns 02-JUL-2020 . You can use this function to perform date math on your date and time data.

Still it is very strange that the date is not getting properly populated in the tables when loading.

It is very hard for me to help you without looking at the data, can you try to offload the data from the database into a text file and see if you can import the data just by uploading and see if the problem persist, I do not think it is related to the source DB but at this point, I just want to start taking variables out of the problem.

If you are able to have a file, and you have some way of anonymizing / creating fake data, it might be useful to load it into Arena so I can take a look at the problem with the specific example.

---

<div class="post-metadata">

**Author:** ![WLS-D](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/wls-d/32/36109_2.png) [@WLS-D](https://community.amazonquick.com/u/WLS-D)\
**Post date:** [May 29, 2024, 5:50pm UTC](https://community.amazonquick.com/t/datos-incorrectos/28834/9 "2024-05-29T17:50:24Z")

</div>

Hi @Santi98,  
It’s been awhile since we last heard from you. Are you still having issues with your original question or were you able to find a work around? If so, feel free to share what worked for you with the community!

If you are still in need of assistance, let us know along with any additional testing you have tried out to make this work. If we do not hear back from you within the next 3 business days, I’ll go ahead and archive this topic. If you have any further questions past that, feel free to create a new topic for discussion.

Thank you!

---

<div class="post-metadata">

**Author:** ![Xclipse](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/xclipse/32/20455_2.png) [@Xclipse](https://community.amazonquick.com/u/Xclipse)\
**Post date:** [June 1, 2024, 3:02am UTC](https://community.amazonquick.com/t/datos-incorrectos/28834/10 "2024-06-01T03:02:16Z")

</div>

Hi @Santi98, I am marking this reply as, “Solution,” in case you need further assistance with your problem, please create a sample dashboard with sample dataset showing your problem state using Arena and please create a new post, so we can look at it from a fresh perspective. (Details on using Arena can be found here - [Quick Sight Arena](https://community.amazonquick.com/t/quicksight-arena-an-embedded-instance-of-quicksight-within-the-quicksight-community/21437))

---

<div class="post-metadata">

**Author:** ![Xclipse](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/xclipse/32/20455_2.png) [@Xclipse](https://community.amazonquick.com/u/Xclipse)\
**Post date:** [June 1, 2024, 3:02am UTC](https://community.amazonquick.com/t/datos-incorrectos/28834/11 "2024-06-01T03:02:27Z")

</div>

Archived on June 1, 2024, 3:02am UTC


