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.
#Reporting/Analytics------------------------------
Eric Muldoon
J.B. Hunt Transport Services, Inc.
------------------------------