
1. Re: calculate 2 weeks average dynamically
Jim Dehner Jan 5, 2018 2:32 PM (in response to Radha Sub)Hi
see attached
it returns this
I modified your formula
as shown
the formula includes a function Mudolo (that is what the % indicates) as written it will return a 0 on the even number points and a 1 on the odds  so it treats the data in pairs like you wnat
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.

CRS Summary_v10.2.twbx 29.4 KB


2. Re: calculate 2 weeks average dynamically
Radha Sub Jan 5, 2018 3:14 PM (in response to Jim Dehner) 
3. Re: calculate 2 weeks average dynamically
Jim Dehner Jan 6, 2018 4:36 AM (in response to Radha Sub)Hi
Glad to help out
see the attached
added a couple of calculations and changed your tool tip
first the week band label
Then a filter to eliminate the gaps in the chart
Now the tooltip
Change it by selecting the Insert button and selecting the fields you want
Now the viz
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.

CRS Summary_ revised_v10.2.twbx 30.1 KB
