This content has been marked as final.
Show 3 replies

1. Re: Standard Deviation from Aggregated Secondary Data Sources
Bora Beran Jun 30, 2017 11:57 PM (in response to Michael Wong)If you'd like to compute the standard deviation of sum(x)/sum(y) you can do window_std(sum(x)/sum(y)).
You can find more about table calculations here

2. Re: Standard Deviation from Aggregated Secondary Data Sources
Michael Wong Jul 5, 2017 10:28 AM (in response to Bora Beran)Thanks Bora, I tried that previously but I'm getting for some reason the same standard deviation across different row dimensions when they clearly should be different. Would you have any suggestions there?

3. Re: Standard Deviation from Aggregated Secondary Data Sources
Bora Beran Jul 6, 2017 12:29 PM (in response to Michael Wong)Tableau calculations are windowed calculations. It will give you the standard deviation across multiple rows of sum(x)/sum(y) data within a specified window. The link I added previously explains how partitioning settings can be used to control the definition of the window which you can adapt to your particular workbook.