Hi everyone, I have a test data set I'm messing around with and I have a problem that I could use some help with I feel I'm just thinking too much into it and it might be simple. But Basically what I'm trying to do is any of the users who input there Index on a Friday, Saturday or Sunday this should actually display as Monday when a report is run every week. I hope I worded that correctly as my English is not the best sometimes. Submission_DateResponders_EmailIndexDay_of_Week10/09/2021User1@Testing.com5Friday10/09/2021User2@Testing.com4Friday10/09/2021User3@Testing.com5Friday10/09/2021User4@Testing.com5Friday10/09/2021User5@Testing.com3Friday18/09/2021User6@Testing.com3Saturday02/10/2021User7@Testing.com5Saturday09/10/2021User8@Testing.com5Saturday16/10/2021User9@Testing.com5Saturday16/10/2021User10@Testing.com3Saturday12/09/2021User11@Testing.com5Sunday26/09/2021User12@Testing.com2Sunday26/09/2021User13@Testing.com6Sunday17/10/2021User14@Testing.com4Sunday31/10/2021User15@Testing.com3Sunday13/09/2021User16@Testing.com2Monday20/09/2021User17@Testing.com5Monday27/09/2021User18@Testing.com6Monday04/10/2021User19@Testing.com1Monday

Ok no problem @Deano478, thanks for clearing that up! I've just added in an expression to handle the [Submission_Date] field as well - how does the following look?

Before:

After:

Shift Day_of_Week to Monday - Generate Rows.yxmd

Ok @Deano478 - in that case we just need to trim off the last couple of steps and apply some extra formatting/clean up to the new fields we've created:

All comments

Hey @Deano478, do you just need the [Day_of_Week] changing here, or are you expecting the dates to be shifted 1/2/3 days as well accordingly?

Hey @DataNath the User Indexes are given the day before (eg. an index sent on Monday is actually for Tuesday & and index given on Friday is actually for Monday) if that makes sense?

So you just want the display of the week day changing like so @Deano478?

Or do you also need days added to the [Submission_Date] field accordingly?

@DataNath I was just messing around with workflow just now and yeah i would need to add days to the [Submission_Date] field accordingly. I appreciate the help with this matter hopefully I'm not frying your head with all the questions

Ok no problem @Deano478, thanks for clearing that up! I've just added in an expression to handle the [Submission_Date] field as well - how does the following look?

Before:

After:

@DataNath I really appreciate the helping hand this looks perfect i can see exactly what you did there and now it makes perfect sense to look at

@DataNath I didn't want to open a whole new topic and I apologise for disturbing you again I just have on follow up question for you relating to the same sample dataset. I just was wondering lets say for Example User1 above enters an index of 2 on Wednesday how could I possibly go about displaying that users index for the rest of the week i.e. Thursday and Friday? again i apologise for for the late follow up.

Your help is much appreciated

Hey @Deano478, no problem! As in you want to create new rows for each User? Or you just want a full list of all the days from the day they entered the index through to Friday in the [Day_of_Week] field, rather than a single day?

Hey @DataNath I just want a full list of all the days from the day they entered the index through to Friday in the [Day_of_Week] field, rather than a single day

Hey @Deano478 - something like this?

hey @DataNath my apologies for the late response Ill give look at the attached workflow now and see and see how it works many thanks again

I had a look there @DataNath I think it might be easier if generate new rows for each user if thats possible

Shift Day_of_Week to Monday - Generate Rows.yxmd

Ok @Deano478 - in that case we just need to trim off the last couple of steps and apply some extra formatting/clean up to the new fields we've created: