Dynamically Rename Column Headers Based on Today’s Date (Rolling 12 Months)

Question & Answer
, , , , , , , ,
1

[Requirements]
We want to dynamically rename column headers to represent the current month and the past 12 months (e.g., if today’s date is 2025-04-16, the column headers should appear as 2025-04, 2025-03, …, 2024-05). These changes should happen automatically based on the current date.

[Options Under Consideration]

  1. Create calculated fields, parameters, and filters that dynamically adjust based on the current date and map them to column headers

    1
    1423×467 9.36 KB

  2. Use the “Insert Parameter” feature under Pivot Options → Column Value Names to dynamically rename headers

    2
    2596×323 5.94 KB

  3. Use a Custom SQL Query with a UNION SELECT approach to reshape the dataset and refresh accordingly

    3
    33675×1453 236 KB

  4. Create parameters and calculated fields in date format, then use these as column names in a pivot or matrix visual

    4
    42719×2455 504 KB

  5. Use grouping functions similar to Excel’s “Date Grouping” and apply the results as column headers

    5
    51838×1353 224 KB

[Important Notes to Be Included in the Answer]
A. While pivot tables are the main use case, other chart types that can achieve the same effect are acceptable
B. Please specify whether the values are treated as int, string, or date types
C. Clarify whether the implementation is done in the Analysis console, the Dataset console, the Dashboard or at the RDS table level

[Points for Clarification & Preferred Answer Style]
Are all the methods (1–5 above) currently supported by QuickSight?

Is there an easy way to implement this without writing custom SQL or complex calculated fields?

2

Hello @HwanJang , welcome to the QuickSight community!

There is no straightforward way to do this in the console unfortunately. If I were doing this and had the option to do it in SQL I would go in that direction. That being said if you want to do it in QuickSight you can use calculated fields, parameters and fitlers like you mentioned in your first option.