I'm currently working on compiling a report in Alteryx and I need assistance with updating a specific value within my dataset. Here's how my data is structured:
Name | 24-Jan | 24-Feb | 24-Mar | Total |
1 req received | 124 | 130 | 117 | 371 |
2 req closed | 87 | 88 | 73 | 248 |
3 req open | 135 | 172 | 209 | 516 |
4 req cancelled | 13 | 3 | 1 | 17 |
This is how i want my output. Please note that the number of columns will be dynamic so if i have 7 columns then the 6th column's value will need to be used
Name | 24-Jan | 24-Feb | 24-Mar | Total |
1 req received | 124 | 130 | 117 | 371 |
2 req closed | 87 | 88 | 73 | 248 |
3 req open | 135 | 172 | 209 | 209 |
4 req cancelled | 13 | 3 | 1 | 17 |
Thank you
Solved! Go to Solution.
@Vineet003 take a look at the flow attached this could help with tranpose and summarise and join to be dynmaic
Hi @Vineet003
Here's one way to do it
First transpose the data and spilt into "3 req open" (bottom) and other (top). Sum the top grouping on Name and take the last value from the bottom. Rename the Value column to Total and union with the top rows. Join this with your original data on Name and the sort to get the original order.
Dan
Thank you @danilang ! :D