Hello! I have a CSV file containing 49881 rows and 29 columns that I imported into Quicksight. However, when I did my analyses, the column, created_date only showed dates in January and not the rest of the year. How do I fix that?
Hi @Syafana,
Can you check if the dates in January and the ones that are not in January are all formatted the same way in your CSV file?
1 Like
Hi @Syafana - Welcome to AWS QuickSight community and thanks for posting the question. Are you observing this in Data Preparation page or in analysis. You can create a small analysis after importing and check all distinct dates or count to confirm whether all records are imported or not.
Regards,
Sanjeeb
Hello, so when I observed the data in the Data Preparation page, I was not able to see the data other than January because I think due to only being able to preview some of the data and when I observed the data in the analysis area, it is still the same. How do I do the small analysis? Also, I’ve tried putting the date and two other columns in another Excel file and tried analyzing it so that I could see if it only does not work on my analysis. I found that Quicksight was able to show all of the dates instead of only January. Hence why, I am quite confused. Hopefully someone can help me. Thank you!
Hi @Syafana,
It’s been awhile since last communication on this thread so wanted to follow up and see if you still had remaining questions or if you were able to find a work around for your case?
If we do not hear back within the next 3 business days, I’ll close out this topic.
Thank you!
Hi @Syafana,
Since we haven’t heard back, I’ll close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.
Thank you!