
1. Re: 18 month rolling calculation from two data sources
Tom W Nov 17, 2016 10:27 AM (in response to Emma Perez)What exactly do you need help with? Can you please provide some more context and upload a Tableau Packaged Workbook including sample data?

2. Re: 18 month rolling calculation from two data sources
Emma Perez Nov 23, 2016 5:41 AM (in response to Emma Perez)Hello,
Thank you for your reply Tom. I have actually found a simple solution to my problem.
I simply created a "table calculation" for both 'errors' and 'work hours.' For the calculation type I used "moving calculation," and for "summarize values using" I chose "sum." I then chose 'date' as a value to move along. I did 17 previous values and included the current value, giving me 18 values total to use for my calculation.
After creating a separate table for both 'error's and 'workhours' I created a forumla in the shelf for my final rolling calculation, as stated above.
I hope this helps someone else.
Thanks,
EP