
15. Re: How to calculate sum of square of each element in the group
Uday Kintali Apr 10, 2018 9:54 AM (in response to Deepak Rai)well, question is same just that I added more dimensions to this than the original question.
Anyway, thanks for your suggestion. I will wait for sometime, if I don't get answers  will close this and open a new thread.

16. Re: How to calculate sum of square of each element in the group
Deepak Rai Apr 10, 2018 9:57 AM (in response to Uday Kintali) 
17. Re: How to calculate sum of square of each element in the group
Uday Kintali Apr 10, 2018 10:18 AM (in response to Deepak Rai)Oh
Attaching again , followed instructions given by Jim.
Hopefully you can now see it.

Sample_Framework_V1.twbx 13.8 KB


18. Re: How to calculate sum of square of each element in the group
Deepak Rai Apr 10, 2018 10:23 AM (in response to Uday Kintali) 
19. Re: How to calculate sum of square of each element in the group
Uday Kintali Apr 10, 2018 7:07 PM (in response to Deepak Rai)Deepak Rai / Jim Dehner  Finally uploading tableau with dummy data. Earlier, I was connecting to a google sheet and no matter what I did it would ask for user credentials for google sheets.
Please find attached tableau. I have only one question :
I am using the formula Jim gave and it is giving me correct value when I have three labels in a test but when there are two it gives me wrong values as noted below.
Formula is generic, so should give correct values irrespective of how many tests are there. Could you please tell me where am I going wrong?
Please let me know if you need more info.
For Test_name = T1 : calculation of stddev_puchasers_lift is correct
For Test_name = T2 : calculation of stddev_puchasers_lift is not correct, when calculating manually i am getting this value as 0.0425

20. Re: How to calculate sum of square of each element in the group
Uday Kintali Apr 11, 2018 9:49 AM (in response to Uday Kintali)Jim Dehner / Deepak Rai  are you guys able to open it now ?

21. Re: How to calculate sum of square of each element in the group
Deepak Rai Apr 11, 2018 10:06 AM (in response to Uday Kintali)Hi Uday,
I can open, but I am not picking it up, because what I gave you was based upon SQUARE, but you say that Jim's method is closer to what you need. So, I would suggest Jim to finish it.
Thanks
Deepak

22. Re: How to calculate sum of square of each element in the group
Jim Dehner Apr 11, 2018 2:29 PM (in response to Uday Kintali)Ok
Sorry I got totally lost in your terminology so I recreated the formulas you see below
this is your original formula now JD yur original formula SQRT(([purchasers_rate]*(1[purchasers_rate]))/SUM([Bucket Size]))
next is JD square of the original formula POWER([JD yur original sqrt pr /bucket size],2)
next is the JD sum of the square formula { FIXED [Test Name]:sum({ INCLUDE [Variation Type]:sum([square std dev PR] )} ) }
Last is the JD sqrt of the sum of the squares power([JD sum of sqrs by test],.5)
it returns this
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.