SOLVED
Dates
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
magsbiel
7 - Meteor
‎09-16-2020
08:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Solved! Go to Solution.
Labels:
- Labels:
- Date Time
4 REPLIES 4
Amarendra
10 - Fireball
‎09-16-2020
09:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
vizAlter
12 - Quasar
‎09-16-2020
09:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎09-17-2020
08:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It worked. Thank you!
‎09-17-2020
08:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Both solutions worked. Thank you!