Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Sorting rows based on color codes

Hello All,   I have a table report where I am having agentname,department,overall tickets completed in my view. I created a measure like below to highlight background color of the rows   Color ...
Need Help
  • olgad's avatar
    olgad
    3 years ago

    Hi, copy paste your Color measure and create Color Sort Measure assigning numbers to your colors, basically instead of your colors you will put numbers according to the sort order they have to be in the table. Then bring this Color Sort to a table, giveit a short name (one letter), sort the table by this color sort. 

     

    Minimize that column till it is hidden, not visible, put a text box with no background on top of the column names only, so noone expands it and sees it.

     

olgad's avatar
olgad
Icon for Resident Rockstar rankResident Rockstar
3 years ago

Hi, copy paste your Color measure and create Color Sort Measure assigning numbers to your colors, basically instead of your colors you will put numbers according to the sort order they have to be in the table. Then bring this Color Sort to a table, giveit a short name (one letter), sort the table by this color sort. 

 

Minimize that column till it is hidden, not visible, put a text box with no background on top of the column names only, so noone expands it and sees it.