Dates

[magsbiel]

Hi,

I need to transpose the data. I have a promotion that is running from 6/28/2020 to 07/26/2020. First I needed to convert those weeks to weeks that the first day of the week is Sunday, which I did, so now the promotion is running from 7/5/2020 to 7/19/2020. Now, I need to take that one row and change to three separate rows with the same attributes, but that will show me each week on the separate line: 7/5/2020, 7/12/2020 and 7/19/2020. I attached current view and desire output. Does anyone know how to do it? 

[Amarendra · Accepted solution]

@magsbiel  Please check the attached solution

[vizAlter · Accepted solution]

@magsbiel  — Hope attached the solution will be helpful, if not let me know.

[magsbiel · Accepted solution]

It worked. Thank you!

[magsbiel]

Both solutions worked. Thank you!