Forum Discussion

anelliaf's avatar
anelliaf
Helper II
1 year ago
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...
Need Help
  • Bmejia's avatar
    Bmejia
    1 year ago

    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"

     

     

     

Bmejia's avatar
Bmejia
Super User
1 year ago

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"

 

 

 

anelliaf's avatar
anelliaf
Helper II
1 year ago

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}
    }
)
 

 

  • Bmejia's avatar
    Bmejia
    Super User
    1 year ago

    make sure both tables are link on TimeBlockelabel and that you are using the Timeblocklable from  your sort table, one showing above.