Hello Community,
I have a date field, where Saturday and Sunday dates are rolled into Monday. I want to summarize the values based on each week's Friday Date. For example, my sample dataset is as given below:
Date | Value | Days | Rolled Days |
2021-01-02 | 1 | Saturday | Monday |
2021-01-03 | 5 | Sunday | Monday |
2021-01-04 | 77 | Monday | Monday |
2021-01-05 | 34 | Tuesday | Tuesday |
2021-01-06 | 24 | Wednesday | Wednesday |
2021-01-07 | 23 | Thursday | Thursday |
2021-01-08 | 21 | Friday | Friday |
2021-01-09 | 53 | Saturday | Monday |
2021-01-10 | 13 | Sunday | Monday |
2021-01-11 | 23 | Monday | Monday |
2021-01-12 | 34 | Tuesday | Tuesday |
2021-01-13 | 12 | Wednesday | Wednesday |
2021-01-14 | 32 | Thursday | Thursday |
2021-01-15 | 13 | Friday | Friday |
In the above table, I want to summarize the entire week's value with each week ending on Friday. This would add the values belonging to each week, i.e., '2021-01-02' to '2021-01-08' and so on. So my expected output would be:
Date | Sum_Value |
2021-01-08 | 185 |
2021-01-15 | 180 |
So far I have been able to convert Dates to Days and then rolled up Saturday and Sunday into Monday. I have attached the sample workflow for reference. Can someone please help me with the solution?
Solved! Go to Solution.
Hey @keeprollin,
Here is one way to do it:
You can create week groups using the multi row formula then summarize the groups using the summarize tool.
Any questions or issues please ask :)
HTH!
Ira