Hi all,
I have a Google Sheets data source and Column A lists the week numbers from 1 to 52. Column B just has a value to each week. I need to create a calculated field dimension so I can order the chart by month.
What formula can I use to accomplish this?
Tried to find a solution via Google Search and Chatgpt but none came with a working solution.