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

[Thableaus · Accepted solution]

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,

[mcha54]

Thank you! I got it to work with a combo of that Multi-Row formula tool and generate rows!