
1. Re: How can I calculate statistical significance versus control groups for pairs of cells?
Brent Hartley Jul 27, 2012 6:03 AM (in response to Brent Hartley)To simplify this challenge, I just need to know how to make Tableau’s calculation logic be like: Do this calculation where the value of the Pair variable for a mail cell equals the value of the Pair variable for the control cell.

2. Re: How can I calculate statistical significance versus control groups for pairs of cells?
Brent Hartley Jul 27, 2012 6:37 AM (in response to Brent Hartley)I think I'm dead in the water. The calculation involves aggregated data.

3. Re: How can I calculate statistical significance versus control groups for pairs of cells?
Joe Mako Jul 28, 2012 12:10 PM (in response to Brent Hartley)Can you please provide the source data that you would connect Tableau to, and an Excel file with the formulas that you want to recreate in Tableau?

4. Re: How can I calculate statistical significance versus control groups for pairs of cells?
Brent Hartley Aug 8, 2012 7:46 AM (in response to Joe Mako)Joe,
Thanks for your willingness to help. I have attached the Excel file with the formulas. I truly wish I could provide the Tableau data, but it's confidential financial data. I've struggled to disguise it but it's just too complex. I have 6 tables joined together to create the dataset, and the linking fields are the ID numbers that I can neither disclose nor can I change their values without losing the connection. I know it's asking too much to have you answer without being able to play around with the data. Thanks all the same.

5. Re: How can I calculate statistical significance versus control groups for pairs of cells?
Joe Mako Aug 8, 2012 4:06 PM (in response to Brent Hartley)Brent,
I would like to help you, but you are currently not enabling that.
Please send me an email, so we can arrange for a webex and hopefully we can find a solution.

6. Re: How can I calculate statistical significance versus control groups for pairs of cells?
minh.nguyen.3 Jun 25, 2015 11:32 AM (in response to Brent Hartley)Hi Joe,
Was this question ever resolved? Did you get a chance to work with Brent via WebEx? I am also interested in adding this type of data into a dashboard for marketing campaign analysis.
Thanks!
Minh