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.
I think I'm dead in the water. The calculation involves aggregated data.
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?
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.
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.
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.