I am trying to create a hidden column based on the Queue Name of each particular row. We have a list of 16 Queues that we currently sort on the first column alphabetically. However, there are 3 of the Queue's that we would like to group together without renaming them. My thought was creating a hidden column that assigns a number to each row based on the Queue name and then sorting on that column.

Example:

Queue_ALL
Queue_Basic
Queue_Day
Queue_Hazmat
Queue_Priority
Queue_Support
Queue_Tech
Queue_Worldwide

We'd like to group Basic, Support, & Worldwide together near the top, like so:

Queue_ALL
Queue_Basic
Queue_Support
Queue_Worldwide
Queue_Day
Queue_Hazmat
Queue_Priority
Queue_Tech

My thought was something like this:

Result =
iif(Queue == "Queue_ALL"), "1";
iif(Queue == "Queue_Basic"), "2";
iif(Queue == "Queue_Support"), "3";
iif(Queue == "Queue_Worldwide"), "4";
iif(Queue == "Queue_Day"), "5";

...etc
And then, sort ascending by the hidden column.

I keep getting "...is undefined" errors trying to reference the Queue name no matter how I try to present it. Queue is a valid Object name in our StatServer Options list. I'm sure I'm missing something simple.

Thanks.

I am trying to create a hidden column based on the Queue Name of each particular row. We have a list of 16 Queues that we currently sort on the first column alphabetically. However, there are 3 of the Queue's that we would like to group together without renaming them. My thought was creating a hidden column that assigns a number to each row based on the Queue name and then sorting on that column.

Example:

Queue_ALL
Queue_Basic
Queue_Day
Queue_Hazmat
Queue_Priority
Queue_Support
Queue_Tech
Queue_Worldwide

We'd like to group Basic, Support, & Worldwide together near the top, like so:

Queue_ALL
Queue_Basic
Queue_Support
Queue_Worldwide
Queue_Day
Queue_Hazmat
Queue_Priority
Queue_Tech

My thought was something like this:

Result =
iif(Queue == "Queue_ALL"), "1";
iif(Queue == "Queue_Basic"), "2";
iif(Queue == "Queue_Support"), "3";
iif(Queue == "Queue_Worldwide"), "4";
iif(Queue == "Queue_Day"), "5";

...etc
And then, sort ascending by the hidden column.

I keep getting "...is undefined" errors trying to reference the Queue name no matter how I try to present it. Queue is a valid Object name in our StatServer Options list. I'm sure I'm missing something simple.

Thanks.

I am trying to create a hidden column based on the Queue Name of each particular row. We have a list of 16 Queues that we currently sort on the first column alphabetically. However, there are 3 of the Queue's that we would like to group together without renaming them. My thought was creating a hidden column that assigns a number to each row based on the Queue name and then sorting on that column.

Example:

Queue_ALL
Queue_Basic
Queue_Day
Queue_Hazmat
Queue_Priority
Queue_Support
Queue_Tech
Queue_Worldwide

We'd like to group Basic, Support, & Worldwide together near the top, like so:

Queue_ALL
Queue_Basic
Queue_Support
Queue_Worldwide
Queue_Day
Queue_Hazmat
Queue_Priority
Queue_Tech

My thought was something like this:

Result =
iif(Queue == "Queue_ALL"), "1";
iif(Queue == "Queue_Basic"), "2";
iif(Queue == "Queue_Support"), "3";
iif(Queue == "Queue_Worldwide"), "4";
iif(Queue == "Queue_Day"), "5";

...etc
And then, sort ascending by the hidden column.

I keep getting "...is undefined" errors trying to reference the Queue name no matter how I try to present it. Queue is a valid Object name in our StatServer Options list. I'm sure I'm missing something simple.

Thanks.

I am trying to create a hidden column based on the Queue Name of each particular row. We have a list of 16 Queues that we currently sort on the first column alphabetically. However, there are 3 of the Queue's that we would like to group together without renaming them. My thought was creating a hidden column that assigns a number to each row based on the Queue name and then sorting on that column.

Example:

Queue_ALL
Queue_Basic
Queue_Day
Queue_Hazmat
Queue_Priority
Queue_Support
Queue_Tech
Queue_Worldwide

We'd like to group Basic, Support, & Worldwide together near the top, like so:

Queue_ALL
Queue_Basic
Queue_Support
Queue_Worldwide
Queue_Day
Queue_Hazmat
Queue_Priority
Queue_Tech

My thought was something like this:

Result =
iif(Queue == "Queue_ALL"), "1";
iif(Queue == "Queue_Basic"), "2";
iif(Queue == "Queue_Support"), "3";
iif(Queue == "Queue_Worldwide"), "4";
iif(Queue == "Queue_Day"), "5";

...etc
And then, sort ascending by the hidden column.

I keep getting "...is undefined" errors trying to reference the Queue name no matter how I try to present it. Queue is a valid Object name in our StatServer Options list. I'm sure I'm missing something simple.

Thanks.