Good afternoon everyone.
I have a table I’m using on quicksight that has values of units sold in the past weeks. Problem is that the name of the columns are “Units (week_1)” , “Units (week_2)” ecc ecc.
Week_1 would be the most recent (last week). Is it possible to change the column names to the actual number of the week? For example, we are today in week 30 and I’d like “Units (week_1)” to become “Units (week_29)” and so on.
I tried for hours but didn’t find any solution.
Thank you so much at anyone that’ll help me!