
1. Re: Question on Table Calculations
Jonathan Drummey Nov 25, 2012 3:17 AM (in response to Alec Guerenstein)Hi Alec,
Could you post a packaged workbook (.twbx) with some sample data, and maybe even a mockup of the desired graph? What you describe isn't sufficient for me to identify where the problem is and what the solution might be.
Jonathan

2. Re: Question on Table Calculations
Alec Guerenstein Nov 25, 2012 7:05 AM (in response to Jonathan Drummey)Hi Jonathan,
Attached the "mockup" design in an Excel file.
As you'll see, Sales is the single measure varying throughout time, and "V" is calculated according to the formula mentioned.
Since the same "V" is based in the timeframe specified, it should be plotted as a horizontal line for the specific time (as a dualaxis, since it's a ratio) .
I am in the middle of the following:
 Duplicating the connection used for "Sales", with no blending or join (to prevent the "rolling effect" I have when using Window_Avg/StdevP)
 Using Parameters to catch Week_From and Week_To (to use them in a Dashboard for both connections)
 Calculating "V" on the secondary measure for the whole window, which is filtered to Week_From/To and hence should remain constant and accurate
Any comments or suggestions are more than Welcome. Thanks for helping out!
Alec.

Volatility Mockup.xlsx 12.6 KB
