
1. Re: 6months rolling average calculation
Jim Dehner May 11, 2018 4:27 AM (in response to Rajesh Narasimha Murthy)good morning
have you tried WINDOW_AVG([Profit Ratio], 6, 0)
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.

2. Re: 6months rolling average calculation
Rajesh Narasimha Murthy May 11, 2018 6:03 AM (in response to Jim Dehner)Thanks for replying with answer.
window avg does not work. I tried already with the below formula
WINDOW_AVG([STP%],6,0)
it's giving the result as 67.99% which looks wrong. if you try doing the average of the percentages mentioned above in the table, you get different result.
please try and let me know if you find different options.

3. Re: 6months rolling average calculation
Jim Dehner May 11, 2018 6:06 AM (in response to Rajesh Narasimha Murthy) 
4. Re: 6months rolling average calculation
Rajesh Narasimha Murthy May 11, 2018 6:22 AM (in response to Jim Dehner)This way, it works. but, I am looking to get just the number. not along with months.
I just want the 68.03% as an independent number to be shown, Not along with the months.
along with the months you get correctly. but, just the number shown is required. if I just drag the moving average calculation to the text I show 67.99% which is wrong. I want the number to be shown as 68.03%
suggest if you have solution

5. Re: 6months rolling average calculation
Jim Dehner May 11, 2018 6:24 AM (in response to Rajesh Narasimha Murthy)I guess i must have missed that in your post
Jim

6. Re: 6months rolling average calculation
Rajesh Narasimha Murthy May 11, 2018 6:48 AM (in response to Jim Dehner)yes, I apologies for not making it clear.
any solution?

7. Re: 6months rolling average calculation
Jim Dehner May 11, 2018 6:55 AM (in response to Rajesh Narasimha Murthy)see attached
the filter
forces the table calculation need to do the rolling average to be done first (out of order in the order of operations)
then you can filter on the date you want without affecting the calculation
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.

6 month rolling2.twbx 13.5 KB


8. Re: 6months rolling average calculation
Rajesh Narasimha Murthy May 11, 2018 7:11 AM (in response to Jim Dehner) 
9. Re: 6months rolling average calculation
Jim Dehner May 11, 2018 7:22 AM (in response to Rajesh Narasimha Murthy)first
you are trying to do a running average calculation  that is a table calculation in tableau
they are on the bottom of the order of operation
you wanted to show only the net result  but to get the result the table that underlies the viz needs to total range of dates
so to show only the last date the process is to use another table calculation (lookup) as a filter
to do that
change the filter to discrete
then
then
Now I understand that you want to notfilter the date to use for other calculations and yet have just the single value for the last date in the serires
the only way I know how to do that is to create 2 worksheets one with the filter and 1 without and bring them together in a dashboard
Jim

10. Re: 6months rolling average calculation
Rajesh Narasimha Murthy May 11, 2018 7:25 AM (in response to Jim Dehner)Thanks for taking the time on this to help. unfortunately, that won't work for my further actions on the workbook.
anybody else have any suggestions?