Reporting and Analytics
Discussion List
-
meaning of threads.seq - and howto filter on itContent Hi all, I've got a small challenge: I try to filter out the 1st contact of a customer within an incident, and my intention is to use the threads.seq field. My as…User_2025-02-03-17-17-22-167 38 views 5 comments 0 points Most recent by User_2025-02-03-19-30-01-975 Reporting & Analytics for B2C Service -
Top align rich text in custom reportContent Hi, I am facing problem in making rich text top align in custom report. In custom report, if you use plain text you will see it all run together but if you are u…User_2025-02-03-20-08-03-425 35 views 2 comments 0 points Most recent by User_2025-02-03-20-08-03-425 Reporting & Analytics for B2C Service
-
How can I create a report that shows all answers with no review date?Content I'm trying to set up a report that shows all public answers in our Knowledge Base that do not have a review date set. I would have thought that a filtering on an…User_2025-02-01-08-35-57-502 37 views 2 comments 0 points Most recent by User_2025-02-01-08-35-57-502 Reporting & Analytics for B2C Service
-
Clickstream Report by Contact for Workspace ReportContent Hello All, I am looking to use the standard Clickstream report that we have and I want to be able to pull the Browser and Version for each user into a separate r…User_2025-02-01-08-40-26-447 27 views 5 comments 0 points Most recent by User_2025-02-03-19-30-01-975 Reporting & Analytics for B2C Service
-
In a nested rollup, display average of lowest levelContent I have a chat report that I have rolled up by Agent and then under each agent, I did a 2nd rollup by the Interval type, So I have two areas, Time as Lead Agent a…User_2025-01-31-02-50-15-254 20 views 1 comment 0 points Most recent by User_2025-02-03-19-30-01-975 Reporting & Analytics for B2C Service
-
Sumifs/Countifs Function?Content Hi there! I am trying to count something in a report that meets criteria in two different text fields. For example, the formula I would use in Excel would be: co…User_2025-02-03-20-32-49-592 52 views 2 comments 0 points Most recent by Satish Iyer-125765 Reporting & Analytics for B2C Service
-
Errors Downloading Cookbook zip filesContent Hello, I tried downloading three different files (Top Keyword Trend, Answer Effectiveness and Answers Not Used) on Chrome and IE on two different computers - one…User_2025-02-03-18-27-59-584 26 views 2 comments 0 points Most recent by User_2025-02-03-20-10-42-447 Reporting & Analytics for B2C Service
-
Report to show number of answers proposed by an accountContent Hello , There is scenario where i am trying to create a report which shows the number of incidents solved, unresolved and answer proposed by a particular agent/ …User_2025-02-03-19-26-15-806 27 views 1 comment 0 points Most recent by Danette Beal Reporting & Analytics for B2C Service
-
Trying to count field with text as a data typeContent Hi there! I'm fairly new to the analytics side of Oracle and I need some help with functions. Specifically, I'm trying to count the number of entries with a spec…User_2025-02-03-20-32-49-592 37 views 2 comments 0 points Most recent by User_2025-02-03-20-32-49-592 Reporting & Analytics for B2C Service
-
Reporting totals in circle LEDContent Hey guys and gals! So I have had a month since MSE and forgot so much. I tried to rewatch the videos but my mind goes blank lol. My problem is.. I want to just s…User_2025-02-03-19-20-35-072 28 views 4 comments 0 points Most recent by User_2025-02-03-19-20-35-072 Reporting & Analytics for B2C Service
-
There has been an error with your request.Content So I have the code has shown below. One column in this report was created by going in to design the report in the console, going to Computed Fields, clicking on …User_2025-02-03-19-49-57-702 27 views 5 comments 0 points Most recent by User_2025-02-03-23-55-43-518 Reporting & Analytics for B2C Service
-
What are the various attributes in transactions table for a status change?Content So I have the below from the transactions table. I see that Attribute 1 is changed to the value of 3 when I choose "Pending Information" for the status. The valu…User_2025-02-03-19-49-57-702 30 views 2 comments 0 points Most recent by User_2025-02-03-19-49-57-702 Reporting & Analytics for B2C Service
-
Averages not working as expectedContent Hi, I'm running two sets of ROQL queries as follows: SELECT Incident.Queue.LookupName as QUEUE, AVG(date_diff(CreatedTime,'2017-05-31 21:10')/86400) as 'AVG' FRO…User_2025-02-03-19-49-57-702 18 views 1 comment 0 points Most recent by User_2025-02-03-19-49-57-702 Reporting & Analytics for B2C Service
-
Add button/image to Quick Search report to Add New Contact/Incident, etcContent Hi, Our agents heavily use the Quick Search functionality to find Contacts, Addresses (a custom object we have) and Incidents. Everything works fine if they find…Craig Hevey 33 views 2 comments 0 points Most recent by Craig Hevey Reporting & Analytics for B2C Service -
Dynamic Search ReportsContent Hello dears, Is it possible to create dynamic search reports? Here is the scenario we are looking to achieve: - User opens the report and gets a filter asking hi…Hanna Abi Akl 38 views 2 comments 0 points Most recent by Danette Beal Reporting & Analytics for B2C Service -
Showing avergae amount of days an incident is open before being resolvedContent As the title says really - anyway we can show this? So if we group by hour, how can we see at any hour between the very start and now, how long on average an inc…User_2025-02-03-19-49-57-702 40 views 2 comments 0 points Most recent by User_2025-02-03-19-49-57-702 Reporting & Analytics for B2C Service
-
Reporting on KB usage across set IP range using clickstreams tableContent Hi everyone I've partially solved this problem, however I hope it can be done easier as currently it completely bogs down my Excel since I have to do a lot of fi…User_2025-02-01-08-17-55-035 54 views 9 comments 0 points Most recent by User_2025-02-01-08-17-55-035 Reporting & Analytics for B2C Service
-
Restart the SLA timestamp when transferring queuesContent Define that the SLA for first response will be 1440 minutes when the ticket is created. I would like that when a ticket is transferred to another queue the time …User_2025-02-03-17-19-40-969 29 views 5 comments 0 points Most recent by User_2025-01-31-22-56-08-446 Reporting & Analytics for B2C Service
-
How can I build a chat "chain of custody" report?Content Hi, I am trying to build a report whereby I can see when a chat request has been declined by one of our agents. So far, I have only been able to find an OOTB rep…James G 34 views 3 comments 0 points Most recent by Kristi Karels Reporting & Analytics for B2C Service
-
If agents don't check 'Send on Save'Content Hi Everyone, I'm new to Right Now. When responding to a guest via email, if 'Send on Save' isn't checked, will a response send to the guest? If not, is there a w…User_2025-02-03-18-55-26-007 53 views 4 comments 0 points Most recent by JBaxter Reporting & Analytics for B2C Service
-
Show all requests by category and then by sourceContent Hi, So the report I need has the columns as the the various types of source and the rows are the different categories Category | Total Raised | Percentage of Tot…User_2025-02-03-19-49-57-702 31 views 8 comments 0 points Most recent by Danette Beal Reporting & Analytics for B2C Service
-
Count time between two dates using a SLAContent Hi, I would like to know how I can calculate a date as SLA calculates the due_date in an incident, but instead of using the incident created date, use a custom d…Guilherme Borges-120430 19 views 2 comments 0 points Most recent by User_2025-02-03-20-45-41-510 Reporting & Analytics for B2C Service
-
Chat Report to show Time when Chatter is waiting for a response from the customer.Content Hello there! Has anyone found or create a report that would detail the time when a chatter is waiting for a response from the customer. I have not been able to f…User_2025-02-01-08-18-48-897 36 views 0 comments 0 points Most recent by User_2025-02-01-08-18-48-897 Reporting & Analytics for B2C Service
-
Analytic Report Row CountContent Hi, I have used a .Net code for fetching Report data.But at a time i can able to fetch only 10,000 data in a report.To overcome those I have used a looping conce…User_2025-02-03-22-23-22-112 61 views 1 comment 0 points Most recent by Lage Antony-121144 Reporting & Analytics for B2C Service
-
Report of 2 survey questions in one surveyContent Hi community, I am having an issue here and I tried a lot of different stuff but unfortunately I cant get it running - hope you guys can help! We have a survey i…User_2025-02-03-17-27-31-522 20 views 6 comments 0 points Most recent by User_2025-02-03-17-27-31-522 Reporting & Analytics for B2C Service
-
Message Base table not showing on the Report tablesContent I'm trying to create a Report to show some Message Base entries but although I find the Message Base table (table "massages") at the data dictionary it is not sh…Douglas Silva 24 views 3 comments 0 points Most recent by Douglas Silva Reporting & Analytics for B2C Service -
Mailings - Detail behind the total opened / unique opens / total cliked / unique clicks etcContent hi folks. I have created a report that lists mailings that have been sent and the sent / opened / clicked / replied / unsubscribed information. I am aware there …Dave Bentley 36 views 2 comments 0 points Most recent by Dave Bentley Reporting & Analytics for B2C Service -
How to index out-of-the-box fieldsContent How do I create an index on a field that came with the Service Cloud application? We are able to create indices on our custom fields via the Object Designer, how…User_2025-02-03-20-25-53-517 39 views 3 comments 0 points Most recent by Danette Beal Reporting & Analytics for B2C Service
-
Report Incidents with Completed Tasks ONLYContent Hi Analytics Gurus, I'm trying to create a report that shows me only those incidents whose tasks have been completed. I can generate a report that shows me incid…User_2025-02-03-18-15-20-995 52 views 3 comments 0 points Most recent by Danette Beal Reporting & Analytics for B2C Service
-
Transactional report (Matrix) results by Incident NumberContent Hello everyone, Do you know if there is a way to generate a report representing results of a matrix - type transactional survey by incident number. I mean the in…User_2025-02-03-19-48-43-179 44 views 4 comments 0 points Most recent by Satish Iyer-125765 Reporting & Analytics for B2C Service