To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting & Analytics for B2C Service
Discussion List
-
Report multiplying data after table joinContent Hi all, firstly I must explain that my knowledge of reporting is very limited so if I am asking a basic question I apologise but I am rather stuck at the moment …User_2025-02-03-22-00-16-925 27 views 1 comment 0 points Most recent by User_2025-02-03-17-57-37-588 -
Answers that errorContent Hi, In Google Analytics I see error ID 1 showing up (Answer no longer available). However, I can't see what answer they were trying to access. I have looked thro…User_2025-02-01-07-03-13-295 28 views 4 comments 0 points Most recent by User_2025-02-01-07-03-13-295
-
Auto Populate Values In The Incident Search reportContent Hi, Greetings, We have a requirement, in the incident workspace which searching for the child incident we need to add the name of the contact as the search crite… -
Monitoring Agent Inboxes - Analytics Cookbook RecipeContent Monitoring Agent Inboxes View All Open Incidents Assigned to My Group Author: Simon Kilgarriff Difficulty rating: (Beginner) Target persona: Agent Supervisors / … -
All vs. Any - Analytics Cookbook RecipeContent "All vs. Any" Reporting Using Multiple Joins to the Same Table to Report on Different Metrics within the Table Author: Simon Kilgarriff Difficulty rating: (Inter…
-
Average Email response time (From all incoming emails)Content Hey guys, I think I have been going through most topics regarding this topic. However, I am still struggling to find an answer. What I am looing for is: Average …User_2025-02-03-17-17-46-546 38 views 2 comments 0 points Most recent by User_2025-02-03-17-17-46-546
-
Format Functionality to Export Option of ReportsContent Can't we edit the format section of the Reports when Exported. Usually the font size is low in the Exported Reports. or Can we have any other functionality to in…
-
How do I obtain an API tokenContent We're trying to use OSC to its fullest "Wow, great stuff, we'll stay with Oracle" potential and connect using a REST API connection to pull data into Alteryx -- …User_2025-02-03-20-43-46-497 62 views 3 comments 0 points Most recent by User_2025-02-03-20-43-46-497
-
Agent assigned incidents report displaying all agents (even with 0 assigned incidents)Content I'm attempting to create a report that displays a count of number of incidents that have been assigned to each agent over a specified amount of time. What I can'… -
Track how many questions are solved via Smart Assistant?Content Hi All, Could we able to track how many questions has been solved through smart assistant widget if the customer has clicked the button as "My question is answer…User_2025-01-25-05-06-24-395 25 views 4 comments 0 points Most recent by User_2025-02-03-18-50-34-224
-
Add field to search on 'Private Messages Per Channel Account' reportContent Hi Group, I'm trying to get help with a report (Private Messages Per Channel Account) that, when you right-click on a record, the option to create an incident ap…
-
Report: On average users are submitting how many tickets per month?Content Hello, I am wanting to reach out and see if there is any way to check on average how many incidents are users submitting via our Ask A Question page in a given m…
-
ROQL: How to use CategoryHierarchyContent I have this: select Category.ID,Category.LookupName, COUNT(ID) as Total from Incident WHERE Source=1017 group by Category.LookupName order by Category.ID LIMIT 2…User_2025-02-03-19-49-57-702 47 views 0 comments 0 points Most recent by User_2025-02-03-19-49-57-702
-
Count incidents when a date_group and count(*) is usedContent I have a report with 3 columns * DATE - date_group(incidents.created,'YYYY-MM-DD') * SOURCE - incidents.source_lvl2 * COUNT - count(*) So this shows how many inc…User_2025-02-03-19-49-57-702 61 views 5 comments 0 points Most recent by User_2025-02-03-19-49-57-702
-
String Replace Function in ReportContent Hi, I want to replace a character in a string in a report column. In the string function, I do not see string replace function? Since I have to access the report…
-
Hide row if a column contains a certain valueContent Is it possible to write a script to hide a row if a column contains a certain value? For example I have a report that displays all the cases for a queue but want…
-
Report - First response SLA from the first customer interaction (calcule)Content Hello, I have a use case that I import a CSV with the customers they bought from the store offering proactive help if they need it. These tickets are created wit…User_2025-02-03-17-19-40-969 21 views 6 comments 0 points Most recent by User_2025-01-29-22-08-41-708
-
PHP with Cross TabContent Hello All I am using Servicecloud to report on Grant information from a Grant Specific CRM. The Servicecloud reporting is considerably better than the Grant CRM.…User_2025-02-03-16-56-52-129 28 views 0 comments 0 points Most recent by User_2025-02-03-16-56-52-129
-
Including transactions disables report record commandsContent Hi Community! While working on improving the quality of data and reduce the amount of duplicate information in the system I have found that by joining the tasks …
-
How to replicate CASE statementsContent MY Query select Source.LookupName as Source, Incident.CustomFields.c.telephone_call as Telephone ,COUNT(*) from Incident WHERE Incident.StatusWithType.Status.ID …User_2025-02-03-19-49-57-702 26 views 2 comments 0 points Most recent by User_2025-02-03-19-49-57-702
-
Separating chat agent intervals by hourContent Hello everyone, We are working on showing the number of minutes that certain agents were available during a specified time period, separated by hour. As of now, …User_2025-02-03-19-46-58-947 21 views 2 comments 0 points Most recent by User_2025-02-03-19-46-58-947
-
Viewing Popular Answers (Report ID 162) in ConsoleContent I'm trying to view the Popular Answers report but no Answers are displayed when I run it. Are CP reports only viewable on a CP Page?User_2025-02-03-18-13-34-376 42 views 3 comments 0 points Most recent by User_2025-01-29-22-08-41-708
-
Can you customize the list of items when you right click within a report?Content Is it possible to hide or add an option when your right click within a report that lists incidents? We need to be able to hide Forward from this list and am unab…
-
Displaying recent/last 5 records based on date/time information in a reportContent Hi, I have a set of reservation/booking data associated with contacts in RightNow. Now I am trying to take out a report where I can group the contacts and take o…User_2025-02-03-17-12-58-131 33 views 2 comments 0 points Most recent by User_2025-02-03-20-38-38-926
-
chat_launch page hit countContent Hello - We are trying to put together a report that will show us how many people land on our chat_launch page after hours. We have tried using the page summary r… -
Fetch last 5 modified recordsContent Hi Team, I have a report that fetches last created record using last(tasks.c$searchtime,tasks.created) formula. But now i want to have last 5 created records. so…User_2025-02-03-17-31-40-230 33 views 3 comments 0 points Most recent by User_2025-02-03-19-31-14-086
-
Validating Report Filter EntriesContent I've built a report that uses a formula to decide what fiscal period a record belongs to. Our fiscal months begin on the 22nd, probably in homage to my birthday …User_2025-02-03-20-43-46-497 17 views 1 comment 0 points Most recent by User_2025-01-29-22-08-41-708
-
Report View as a specific Account User when testing ReportsContent I'm an admin creating reports for my company's OSC implementation. I'm creating reports that I know will be used by users in a specific profile/nav set. As the a…User_2025-02-03-18-15-20-995 16 views 2 comments 0 points Most recent by User_2025-02-03-22-34-08-805
-
Filter in ExpressionContent How we can we use the filter on a report in an expression?User_2025-02-03-19-49-57-702 37 views 4 comments 0 points Most recent by User_2025-01-29-22-08-41-708
-
Help to Improve Efficiency of Transactions Query?Content Hi all, I recently rebuilt one of our oooooold reports that was originally created by my predecessor in the role. The original would break querying a days worth …