This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Find answers, ask questions, and share expertise about Alteryx Designer.
General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!
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.
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.
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.