Hello,
Why did this error occur?
Best,
Vaibhav.
Looks like the date field you are using might not have Day in it. Because the field name says (Month-year). Please correct me if i am wrong.
The most probable reason for this error is a mismatch between the expected data type and the actual data in the ‘Month-year’ field.
The extract function in QuickSight expects a date or datetime field to work with. For example, extract(‘DD’, some_date_field) would extract the day from a proper date field like 2023-10-15, returning 15.
However, ‘Month-year’ (as a field name or value) suggests that the field might not be a full date. If ‘Month-year’ contains values like October-2023 or 10-2023, it’s likely stored as a string or a partial date, not a full date (e.g., 2023-10-01).
The extract(‘DD’, …) function specifically looks for the day component, but if ‘Month-year’ doesn’t include a day (e.g., it’s just October-2023), QuickSight cannot extract a day, leading to an error when trying to save the calculated field.
Please let me know if this helps.
Thank you,
Shravya
1 Like
1 Like