Hello All,
I am new to Alteryx and have been trying to figure out how to do basic mathematical functions (percentages and additions) in a table.The original table is as follows:
| | Monday | Tuesday |
| Sent | 150 | 100 |
| Undelivered | 20 | 15 |
| Delivered but not opened | 90 | 50 |
| Opened | 25 | 10 |
| Clicked | 15 | 25 |
Following are the transformations I want to carry out and then get the output:
1. Instead of the "undelivered" row, I want it to say "Delivered" where Delivered = Sent - Undelivered
2. Add a % column in front of each Monday and Tuesday fields and calculate percentages based on the following formulas:
- % delivered = (Delivered / Sent) *100
- % delivered but not opened = (Delivered but not opened/Delivered)*100
- % opened = (Opened/Delivered)*100
- % clicked = (Clicked/Delivered)*100
Hence after this, the output should look like the follows:
| | Monday | % Monday | Tuesday | % Tuesday |
| Sent | 150 | | 100 | |
| Delivered | 130 | 86.7% | 85 | 85.0% |
| Delivered but not opened | 90 | 69.2% | 50 | 58.8% |
| Opened | 25 | 19.2% | 10 | 11.8% |
| Clicked | 15 | 11.5% | 25 | 29.4% |
I have been struggling with cross-tabs and summarize tools to do this transformation. I am attaching the excel for the same (the input file).
In case you might be thinking why not do it on Excel, I have thousands of similar tables with me and this is the only format in which it is given to me so Alteryx is the only way to analyze it.
It will be great if all amazing people of this community can help me with the workflow.
