I’m using a simple table and once I add a Date field it add a aggregation by default. Is there anyway to no aggregate?
My column is timeframe and I want to show values with data and time with milliseconds and it’s aggregation by seconds. With that I lost some values.
I saw that I can add a calculation field where I can cast the date as String. But I have two problems with that, first I can not display in the same format as the function “formatDate” has only some options and second is that I need sort by this filed and once I sort by the String It not take in account the dates …
Sorry, currently this feature is not support formatDate the exact format you need (e.g., including milliseconds), you may need to display the date and time as a combination of fields (e.g., concatenating date and time fields separately).
You can also try editing your dataset directly in Quick Sight by changing the data type of your datetime field to a string:
Edit the Dataset:
Go to your dataset in Quick Sight and select “Edit”.
Locate the datetime field and change its data type to String.
Date fields are usually aggregated by default (e.g., by day, hour, or minute). To prevent this, ensure that the date field is set as a dimension instead of a measure.
In the Field Well of your table, drag the date field into the “Rows” section.
Make sure it is categorized as a dimension (not aggregated). This will display each unique date and time entry as it is.
Please refer the below documentation this might be helpful for you.
Hi @igfasouza,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for any relevant information that may be needed.
