Forum Discussion
Matrix Column sort following an IF statement
I have a set of data that has dates in it and added a column in the data view (Because i didnt know how to do it in query editor) with the following statement:
Overdue Status = IF([Due Date]<TODAY(),"Overdue", IF([Due Date]-30<TODAY(), "Next 30 Days", "30+ Days Away"))
Hello astorey1
The easiest way to do this is by creating a new column that represents your sort order and use the "Sort by column" option in the modelling ribon.
Overdue Status = IF([Due Date]<TODAY(),1, IF([Due Date]-30<TODAY(), 2, 3))Kind regards
Joren Venema
Data & Analytics Consultant
If this reply solved your question be sure to mark this post as the solution to help others find the answer more easily.
2 Replies
Hello astorey1
The easiest way to do this is by creating a new column that represents your sort order and use the "Sort by column" option in the modelling ribon.
Overdue Status = IF([Due Date]<TODAY(),1, IF([Due Date]-30<TODAY(), 2, 3))Kind regards
Joren Venema
Data & Analytics Consultant
If this reply solved your question be sure to mark this post as the solution to help others find the answer more easily.Following are the steps:
Sort each row of the matrix.
Get transpose of the matrix.
Again sort each row of the matrix.
Again get transpose of the matrix.
Algorithm for sorting each row of matrix using C++ STL sort():for (int i = 0 ; i < n; i++)
sort(mat[i], mat[i] + n);
Algorithm for getting transpose of the matrix:for (int i = 0; i < n; i++) {
for (int j = i + 1; i < n; i++) {
int temp = mat[i][j];
mat[i][j] = mat[j][i];
mat[j][i] = temp;
}
}I hope this helps!
Regards,
Lewis
Tech-consultant