30 Day Rolling after every seven days or Sunday

[agoel20]

Hi All,

I have daily data for a given time period, but I want to calculate previous 30 days rolling sum from a given date in the data only after 7 seven days or every Sunday which means I do not want previous 30 day rolling sum for every day but after every 7 days, I have attached a sample dataset. Appreciate the help from the community.

[Pang_Hee_Choy]

please give an example output. 

it help people to understand further.

[DawnDuong]

Hi @agoel20 

Maybe it's just me, I do not 100% understand the description. Can you post a sample input vs. expected output to illustrate? It will be clearer. 

Dawn.

[RolandSchubert]

Hi @agoel20 ,

if I got you right, you want to aggregate the last 30 days only on Sunday - like this?

You can use a Multi-Row Formula tool to check, if current date is Sunday and only if true aggregate last 30 days. Not very elegant, but works.

 

Let me know if it works for you (or if I did not understand correctly, what you need).

Best,

Roland