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
-
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 / … -
NetPromoter Score (NPS) - Analytics Cookbook RecipeContent NetPromoter Score (NPS) Calculating Your NPS for the Last 7 Days Author: Simon Kilgarriff Difficulty rating: (Intermediate) Target persona: Marketing/Survey Anal…
-
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…
-
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 23 views 1 comment 0 points Most recent by User_2025-02-03-17-57-37-588 -
Contacts DeletedContent Hi, is there any way to obtain those contacts that were deleted from the database? Is there any audith log to look for this in? RegardsUser_2025-02-03-18-08-05-360 17 views 4 comments 0 points Most recent by User_2025-02-03-16-51-39-328
-
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… -
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 34 views 2 comments 0 points Most recent by User_2025-02-03-17-17-46-546
-
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'… -
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 42 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 57 views 5 comments 0 points Most recent by User_2025-02-03-19-49-57-702
-
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 23 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 24 views 2 comments 0 points Most recent by User_2025-02-03-19-49-57-702
-
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…
-
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 36 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…
-
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 58 views 3 comments 0 points Most recent by User_2025-02-03-20-43-46-497
-
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… -
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 27 views 2 comments 0 points Most recent by User_2025-02-03-20-38-38-926
-
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 13 views 1 comment 0 points Most recent by User_2025-01-29-22-08-41-708
-
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 26 views 3 comments 0 points Most recent by User_2025-02-03-19-31-14-086
-
Filter in ExpressionContent How we can we use the filter on a report in an expression?User_2025-02-03-19-49-57-702 33 views 4 comments 0 points Most recent by User_2025-01-29-22-08-41-708
-
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 18 views 2 comments 0 points Most recent by User_2025-02-03-19-46-58-947
-
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 … -
Scheduled Reports - Record Limit - VRL_HARD - configuration settingContent We have some scheduled reports that are being cut off at the 15000 record limit. Just want to confirm if increasing the VRL_HARD - configuration setting will car… -
Create custom report with Audit log of Account managementContent Hi all, I looking for generate a report where are centralice all staff account changes (Create, Update, Delete) with information field time created, user name, a…User_2025-02-03-17-57-33-602 60 views 4 comments 3 points Most recent by User_2025-02-03-17-57-33-602
-
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 14 views 6 comments 0 points Most recent by User_2025-01-29-22-08-41-708
-
ROQL Multiple FiltersContent Currently have the below but looks like just the second one is listened to and not the first, please advise how I'd pass multiple filters using ROQL to an analyt…