
1. Re: Combining Moving Average with Percent of Total
Joe Mako Jan 26, 2013 7:37 AM (in response to Dan Meier)Dan,
You have a few options and routes to get the results you are looking for. The key that you are looking for is that if you have separate calculated fields, you can have different compute using configurations for each calculated field.
In the attached,
1. added two calculated fields:
Total:
TOTAL(SUM([Unit Count]))
Moving Average  Nested:
WINDOW_SUM(SUM([Unit Count]),5,0)
/
WINDOW_SUM([Total],5,0)
2. placed the Moving Average  Nested field on the Rows shelf.
3. from the pill's context menu, selected Edit Table Calculation
4. configured the compute using for Moving Average  Nested
5, changed the Calculated Field dropdown to Total, and configured its compute using
In Tableau, the pill that you select for compute using will be used for addressing, and all other dimension pills will be used for partitioning that calculation.
This was just a light walk through, I would be glad to explain in more detail if you contact me.