Reporting and Analytics for Service

Get Involved. Join the Conversation.

Topic

    Pavol Procka
    Custom Sorting/Ordering based on a Hidden ColumnAnswered
    Topic posted December 28, 2017 by Pavol ProckaSilver Crown: 22,500+ Points, last edited December 28, 2017 
    133 Views, 7 Comments
    Title:
    Custom Sorting/Ordering based on a Hidden Column
    Content:

    Hi,

     

    I have a report based on the "chat_queue_stats_rt" table and would like to create a custom order for the displayed queues (other than alphabetical - I need specific queues to show on top). I was hoping to add a hidden column where I would manually give some queues a value of 1 and other queues a value of 2 and then sort based on this but am getting an error that says: "Non-database fields may be used only as single-column references."

    I assume it is because of the table I am using, not sure what can be done to solve it? (I would like to retain the real time values).

    The Expression I was using for my hidden column was if(chat_queue_stats_rt.queue_id=341,'1','2')

    So I am trying to show the Q with ID 341 on the top and the rest below

     

    Best Comment

    Gursimran Singh Saini

    Hey Pavol,

    See the attached screenshot. The sliced Queues are in a custom sorting order. This is what I meant.

    If this doesn't work for you, go for a dashboard having two reports.
    Report 1 - Location's Prioritised Chat Queues
    Report 2 - Location's Backup Chat Queues

    Comment

     

    • Suresh Thirukoti

      This table looks like pseudo table so no typical privileges of database column



      https://cx.rightnow.com/app/answers/detail/a_id/6177



      https://cloudcustomerconnect.oracle.com/posts/1c5965864b



      ~Suresh

    • Pavol Procka

      Thanks, I was afraid that is the case. Any suggestions on how to achieve what I need here anyone?

      I would prefer not to use a dashboard with two reports.

    • Gursimran Singh Saini

      Well there is one way of sorting Queues.

      Try Slice.
      Under Slice By, choose Buckets and Slice Column = Queue
      The Buckets are sorted by the order you create them.

      In a way Queues are sorted. On the left side.

    • Pavol Procka

      Hi Gursimran,

       

      this looks promising and I tried but when I create a Bucket, I use the In List Operator and then Enter the Qs they do appear under the slice, but still in the same order as before - no matter in which order I enter them - they still are ordered alphabetically (ordering on the queues column).

      What I am trying to achieve is to manually change the order of the displayed Qs, while keeping the realtime data (chat_queue_stats_rt). Basically the reason for this is that we have 2 locations and each location manages certain Qs as priority, but they still want to see all the Qs in the chat monitor report as they also act as a backup for the remaining Qs.

      Is there something I am missing here maybe?

       

      Many Thanks

       

      Pavol

    • Gursimran Singh Saini

      Hey Pavol,

      See the attached screenshot. The sliced Queues are in a custom sorting order. This is what I meant.

      If this doesn't work for you, go for a dashboard having two reports.
      Report 1 - Location's Prioritised Chat Queues
      Report 2 - Location's Backup Chat Queues

    • Pavol Procka

      Hi Gursimran,

      thanks for the reply. I actually wanted to get the queues re-arranged directly in the report. I get how you can arrange the slices in a custom order, however the queues within the slice still stay the same. So if I have queues A, B and C, there is no way to have B on top within one report (of course unless there is a situation where there is an another column that has highest/lowest value - but since these are real-time results, that is not the way to go). Looks like this (custom, or even manual sorting) can at best go to slowly grow old in the Idea Lab...

      Anyway, thanks for your advice, at least I learned something new. I am chosing your answer as best, as the dashboard indeed seems to be the only way, even if I was trying to avoid that :)

      Pavol

    • Erica (Leep) Anderson

      Thanks for sharing what you learned in the process and marking a best answer, Pavol.

      ~Erica, Oracle Service Cloud