Hello!
I have this as my input
Weeks Out | Weeks Out Date | Data Through |
0 | 8/25/2025 | 8/24/2025 |
1 | 8/18/2025 | 8/17/2025 |
I want to expand my weeks out date so that multiple dates are showing. Here is the desired output. Not sure how to go about it.
Weeks Out | Weeks Out Date | Data Through |
0 | 8/31/2025 | 8/24/2025 |
0 | 8/30/2025 | 8/24/2025 |
0 | 8/29/2025 | 8/24/2025 |
0 | 8/28/2025 | 8/24/2025 |
0 | 8/27/2025 | 8/24/2025 |
0 | 8/26/2025 | 8/24/2025 |
0 | 8/25/2025 | 8/24/2025 |
1 | 8/24/2025 | 8/17/2025 |
1 | 8/23/2025 | 8/17/2025 |
1 | 8/22/2025 | 8/17/2025 |
1 | 8/21/2025 | 8/17/2025 |
1 | 8/20/2025 | 8/17/2025 |
1 | 8/19/2025 | 8/17/2025 |
1 | 8/18/2025 | 8/17/2025 |
Solved! Go to Solution.
@bryanmac_92 Here is a way to do it.
Get the date fields into the date format then use a generate rows tool to add a date until it's a week out for each record.
There are other ways to reformat the dates but this is the easiest for me.
Bacon
User | Count |
---|---|
60 | |
24 | |
24 | |
21 | |
21 |