Hi Guys,
I hope that all are well. I need sum diagonal values in a matrix (table) with Alteryx. How do solve this problem?
Example:
Thanks!
Igor Valle
How extensive is your table? In this instance you could do it with a simple multi-row formula using [C]+[Row-1:B]+[Row-2:A]. However, if you have a load of columns you may need to start looking at transformation and likely macros to handle the logic. Can you provide a screenshot/sample of the size of the live dataset if this isn’t the case?
Just re-read the table based on the colouring and that actually wouldn’t work sorry! If nobody offers up a solution I’ll have a play around with this tomorrow.
Hi DataNath,
Thank you for your help. My table/matrix has a maximum size of 244 rows and 100 columns.
Igor Valle
@igorfv See if the attached works for you. It took a few extra tools, but it should work for tables of different sizes. The thought is to get a rowID and ColumnID for each cell, and then sum it together do each cell. Notice that diagonals all have the same sum:
User | Count |
---|---|
107 | |
82 | |
70 | |
54 | |
40 |