Alteryx Analytics Hub

Find answers, ask questions, and share expertise about Alteryx Analytics Hub.

30 Day Rolling after every seven days or Sunday

agoel20
5 - Atom

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.

 

 

1 REPLY 1
Pang_Hee_Choy
9 - Comet

please give an example output. 

 

it help people to understand further.

Labels