Hi All,
addDateTime(extract(‘WD’, addDateTime(-1, ‘DD’, ${SelectedDate})), ‘DD’, truncDate(‘WK’, addDateTime(- extract(‘WD’, addDateTime(-1, ‘DD’, ${SelectedDate})),‘DD’,{line_item_usage_date})))
I am able to get the data correctly however, I would like to show column names in the format of
eg. 14-Jun-2024 - 20-Jun-2024
currently the column name just showing only one date which is start of the week. Please find attached screenshot for the reference.
Could you please help advise how we can show the column names in the “start week date - end week date.” format
Would highly appreciate the response.
Thank you
duncan
June 21, 2024, 9:32pm
2
Hello @Amit_Raj , welcome to the Quicksight community!
You may be able to use a calculated field similar to the second calculation described in the solution of this post:
Hi team,
I have a use case where I need to have dynamic headers in a table. Specifically, I need the last 5 weeks to automatically get updated with the new week as time progresses.
For example, I need to have the last 5 weeks displayed in the columns, along with their corresponding week numbers. I know that this is possible to do using parameters, but I’m finding it challenging to implement based on the documentation.
Could you please provide some guidance or suggestions on how I can achieve …
Where you use your original calculated field to determine the dates and then concat them.
Hi @Amit_Raj , did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community!
@duncan ! and @Xclipse ! yes indeed it worked!
1 Like
