Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Custom Sorting/Ordering based on a Hidden Column

edited Dec 28, 2017 3:48PM in Reporting & Analytics for B2C Service 7 comments

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!