Generating dates and other values

mcha54

Hi! I'm trying to generate some rows of dates, but also need to populate the week as well.

I start with "Week 0", the date range for the week, and then a date for how far back to go.

The generate rows tool works but doesn't let me update/create other fields.

Input

Output

Week 0 Create.yxmd

Thableaus

Hi @mcha54 

An idea would be adding a Multi-Row Formula Tool and updating the Week Field, grouping by ID according to the rule:

IF [Row-1:Start] != [Start] then [Row-1:Week] + 1

ELSE [Row-1:Week] ENDIF

Set Values of Closest Valid Row option must be checked as well.

Cheers,