Need to add dynamic date to workflow

Hi All,

I've searched through past posts and can't seem to find what I need. I provide a weekly report (previous Sunday - Saturday data) and the data I'm pulling has 2 weeks worth of requests with Open Timestamps. I have a filter to pull out the dates I need (e.g., the previous Sun 2/14 to previous Saturday 2/20), but for Tableau I need to add in the missing dates. Currently I have a text input with manual dates, however I think there has to be a formula to add in the date for last Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, and Saturday. I've attached a photo and excel workbook with the data from the report I am working on today.

Thank you very much!

Alteryx Date Issue_MM.xlsx

Alteryx Date Issue_MM.PNG

Date Time

Help

Accepted answers

Emil_Kos

Hi @MichelleMitchellLutz,

It should work for you:

The output

The workflow is fully dynamic and it looks at today date in order to calculate the seven days.

Today.yxmd

All comments

messi007

@MichelleMitchellLutz,

I'm not sure to understand well your need but what I get is you need to add the days between last Sunday and the date populated on the column Opened Timestamp.

Attached the workflow.

Hope this helps,

Regards,

AddDates20210223.yxmd

pedrodrfaria

Hi @MichelleMitchellLutz

I attached the workflow below. I think this should give you a good idea of how to approach this issue. I went ahead and created some more data to show you how it would create the additional dates that were not included.

Pedro.

Need to add dynamic date to workflow.yxmd

MichelleMitchellLutz

Hi!

Thank you for looking at it. I need to add in the missing days, but they won't always be the same (not always missing a Wednesday, etc.), so I wanted to add a formula to add the previous Sunday - Saturday.

MichelleMitchellLutz

Thank you! I need to add in dates for every day of the previous week (see below). The issue is that each week it is different, so I really need to add in dates for every day of the previous week.

Sunday 2/14 - NEED TO ADD

Monday 2/15 - in the data

Tuesday 2/16 - in the data

Wednesday 2/17 - in the data

Thursday 2/18 - in the data

Friday 2/19 - in the data

Saturday 2/20 - NEED TO ADD

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703