Forum Discussion
Solved
Matrix Visual - Sort by Day Of Week and Column Bucket
I'm using a Matrix visual to display events by Day of Week (rows) and time blocks (columns, e.g., 12a–5a, 6a–11a, etc.). I've created custom columns with corresponding sort columns (DayOfWeekNum, Tim...
Hi,
It would be important to see the table structure, but the sort column should be done only on your header column within the table. Create a column with the sort colum values like "SortColumn" below using a conditional column or table that can reference the sort values. Then go to "Column tools" and select the column1 header and then click on "Sort by column" and select "SortColumn"
Here's what I have for the time blocks and I'm already sorting by the timeblocksort column.
AuditTimeBlockTable =
DATATABLE(
"TimeBlockLabel", STRING,
"TimeBlockSort", INTEGER,
{
{"12a–5a", 1},
{"6a–11a", 2},
{"12p–5p", 3},
{"6p–11p", 4}
}
)
make sure both tables are link on TimeBlockelabel and that you are using the Timeblocklable from your sort table, one showing above.