[Screenshot 2025-07-28 at 12.01.47 PM] I have a dashboard with parameters and calculated field that makes it to be able to aggregated to daily/weekly/monthly/quarterly level, here is the calculated field Time Granularity = ifelse( ${TimeGranularity} = ‘Daily’,truncDate(‘DD’, {reporting_period})…

Thank you for sharing the article! I tried the same method in the article, but it didn’t work for me because I have a Period over Period column(calculated field) that calculates the difference between each day/week/month/quarter. If change the date format to a string, that calculated field is not go…

Hi @Bonnie213 , You are correct, it is because of the data type difference. Can you try using formatDate function to format the date returns as string also? formatDate - Amazon QuickSight Use the formatDate function for calculated fields in Amazon QuickSight. …

I’ll have to add both field(date and string) to the pivot table so my dashboard can be able to switch to daily/weekly/monthly/quarterly level. I planed to use the string one for displaying and the date one for controlling the time granularity(and I can hide this field in the dashboard) But this meth…

Hi @Bonnie213 , Hope everything is well with you! I noticed that this topic has been open for a while and wanted to check in to see if you have found a solution since. If not, feel free to let us know if there are any persisting issues we can help with. If we do not receive a response within 3 busin…

Hi @Bonnie213 , Since we have not heard back, I’ll go ahead and close 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. Thanks!

Custom quarter date format

Q&A

apjvinod July 29, 2025, 3:00am 2

Hi @Bonnie213

Could you please go thru this article and it explains how to do different date formatting dynamically .

Topic		Replies	Views
Feature Request: Dynamic formatting date values based on parameter Q&A filters , formatting , feature-request , quick-sight , Business-Intelligence-Engineer	2	107	September 3, 2024
Dynamic formatting values based on parameter Q&A analysis , filters , formatting , quick-sight , visuals , Business-Intelligence-Engineer	11	263	September 13, 2024
Dynamic date and periods Q&A filters , calculation , calculations-editor , formatting , calculated-field , quick-sight , calculations , Business-Intelligence-Engineer	1	161	April 15, 2024
How to show Quarter as Q1-year, Q2-year, values on drop down Q&A analysis , quick-sight , filters-controls-and-parameters , Business-Intelligence-Engineer	13	217	August 26, 2025
Year,Quarter,Week Format Issue Q&A formatting , feature-request , quick-sight , calculations , Business-Intelligence-Engineer	1	445	September 26, 2023

Custom quarter date format

Related topics