I have the following table, and I am wondering how to get the week number in a new column using the date column in Data Studio?
ID
Date
1
1 Jan 2022
2
23 Feb 2022
I understand that I need to use a formula, but I am unsure how to do this.
I also would like the table to look something like this:
ID
Date
Week Number
1
1 Jan 2022
1
2
23 Feb 2022
8
