
1. Re: Standard Devation and Variance Weighted
Sherzodbek Ibragimov Oct 28, 2016 5:40 AM (in response to Randy Adhitama Setiadi)RAndy
tableau has its own built in calculations, including stndard deviation. when you drop you measure right click and change your default aggregation to other measure as you need. Also there is another option. There is summary card option In Worksheet tab/Show summary. I hope it helps.

2. Re: Standard Devation and Variance Weighted
Sherzodbek Ibragimov Oct 28, 2016 6:02 AM (in response to Sherzodbek Ibragimov)This is link to show summary if it works for you: Summary Card
If it doesn't help you then you may want to use ATTR () in front of your each non aggregate field. Try it if it doesn't work please post your mock data.

3. Re: Standard Devation and Variance Weighted
Sherzodbek Ibragimov Oct 28, 2016 7:47 AM (in response to Randy Adhitama Setiadi) 
4. Re: Standard Devation and Variance Weighted
Randy Adhitama Setiadi Oct 29, 2016 7:38 PM (in response to Sherzodbek Ibragimov)Thank you for feedback
I'm quite aware of tableau feature to calculate sum, stdev, var, etc. But I believed that feature cannot be used for weighted data, because to average, standard deviation or variance between weighted and unweighted data has totally different formula.
Any other solution?
Thanks
Randy

5. Re: Standard Devation and Variance Weighted
Sherzodbek Ibragimov Oct 29, 2016 8:45 PM (in response to Randy Adhitama Setiadi)Randy
can you please post your sample data and how you tried to get formula with error message. We maybe able either fix your formula or get another calculation

6. Re: Standard Devation and Variance Weighted
Randy Adhitama Setiadi Oct 30, 2016 5:36 AM (in response to Sherzodbek Ibragimov)
Weighted Calculation.twbx 28.5 KB


7. Re: Standard Devation and Variance Weighted
Sherzodbek Ibragimov Nov 1, 2016 11:11 AM (in response to Randy Adhitama Setiadi)I am getting several different numbers based on where I place (), so would be able to post what your final numbers should be for Imagery, right. Thanks

8. Re: Standard Devation and Variance Weighted
Randy Adhitama Setiadi Dec 14, 2016 2:29 AM (in response to Sherzodbek Ibragimov)Sorry for very late post, I'm kind of stuck to get the standard deviation weighted for my example, even using another apps. Would you mind to share your formula? I will confirm it with my original data.
Thanks
Randy