-
1. Re: Weekly average based on last 7 days
Madhusudhan Khambham Feb 19, 2017 11:25 AM (in response to Nat Vats)Please find the attached workbook. Please refer sheet 4.
Is this what you are expecting?
Thanks
Madhu K
-
WeeklyAverage.twbx 22.6 KB
-
-
2. Re: Weekly average based on last 7 days
Norbert MaijoorFeb 19, 2017 10:44 AM (in response to Madhusudhan Khambham)
Hi Nat,
Find my approach based on datepart-function below as reference and stored in attached workbook version 9.3 located in original threat.
Step 1: define week based on start week tuesday
Week: datepart('week', [Asofdate],'tuesday')
-
WeeklyAverage_nalmai.twbx 21.8 KB
-
-
3. Re: Weekly average based on last 7 days
Nat Vats Feb 19, 2017 12:07 PM (in response to Madhusudhan Khambham)Thanks for your response. In my case week end date is the date for which report is run and start date is (end date-7).
In your case your week starts at 22nd, 15th.
-
4. Re: Weekly average based on last 7 days
Madhusudhan Khambham Feb 19, 2017 12:54 PM (in response to Nat Vats)1 of 1 people found this helpfulI believe this is what you are expecting. Otherwise please share the expected result.
Thanks
Madhu K
-
5. Re: Weekly average based on last 7 days
Nat Vats Feb 19, 2017 4:05 PM (in response to Madhusudhan Khambham)Can you share the workbook?
-
6. Re: Weekly average based on last 7 days
Madhusudhan Khambham Feb 19, 2017 4:23 PM (in response to Nat Vats)Hi Nat Vats
Good to hear that it satisfied your requirement.
Attached the workbook for your reference.
Thanks
Madhu K
-
WeeklyAverage.twbx 20.3 KB
-