Reporting and Analytics
Discussion List
-
Set report to deferred execution - Unable to save the settingsContent Hi, We have a report that is very useful for the Knowledge managers and they do not want any changes to that. We have optimized it to the extent possible but at …Pratyush Sharma-113976 52 views 1 comment 0 points Most recent by Carl Elliott Reporting & Analytics for B2C Service -
RunAnalyticsReport filtering based on sysdateContent Hi, I am running the analytics report in my SOAPUI and getting the output. I now need to specify a filter within the input payload so as to return only the incid…Vignesh Nagarajan-126051 41 views 2 comments 0 points Most recent by Vignesh Nagarajan-126051 Reporting & Analytics for B2C Service -
Survey Report Product WiseContent Hi, We need to create survey activity report product wise.From the surveys,mailings & mailings format table I can get all the required columns like number of cli… -
Reporting questions from Texas User Group meetingContent There were a number of questions regarding reporting and Vimal has provided some resources: Performance best practices whitepaper (and corresponding Modern Servi…Steve Mintz 18 views 2 comments 1 point Most recent by Steve Mintz Reporting & Analytics for B2C Service
-
Questions involving the Type column of the Transactions tableContent I have a column to track incidents created for live chat: sum(if(transactions.trans_type=2&transactions.source_lvl2=1017,1)) We have the incidents set to be crea…Nick L-113854 25 views 0 comments 0 points Most recent by Nick L-113854 Reporting & Analytics for B2C Service -
Inline editing option is disabled optionContent Hi All, I have created a custom report for Incident and give permissions to edit the report for the profile level and in report level. But, the inline editing op…Muthulakshmi Muthaiah-121678 32 views 1 comment 0 points Most recent by Dietrik -120086 Reporting & Analytics for B2C Service -
Comparison Columns, need assistance interpreting documentationContent I want to build a report that compares aggregate chats weekly by queue, week over week, with additional columns indicating the percentage change +- between the w…Dan Clegg-119885 30 views 0 comments 0 points Most recent by Dan Clegg-119885 Reporting & Analytics for B2C Service -
Modify Agent Activity Report to count all responses send by AgentContent We are looking at Oracle's OOTB report - Agent Activity. Report ID: 55 We are trying to capture * Outgoing emails by the Agents * and emails that are being respo…Ajay John 30 views 1 comment 0 points Most recent by Carl Elliott Reporting & Analytics for B2C Service -
Use Custom Scripts as FiltersContent I have a report that already uses custom scripts to do a certain calculation. However, I want to know if it's possible to use custom scripts as filters? Version …Marv Ferrer 41 views 1 comment 0 points Most recent by Marv Ferrer Reporting & Analytics for B2C Service -
Hourly Incident Activity Today - Analytics Cookbook RecipeContent Incident Activity Hourly Incidents Activity Today Author: Bastiaan van der Kooij Independent Oracle Service Cloud Consultant Difficulty rating: (Advanced) Target…Bastiaan van der Kooij 153 views 3 comments 9 points Most recent by Kristi Karels Reporting & Analytics for B2C Service -
Get data of Current Fiscal Year-Month WiseContent 1. To list the months: Our Fiscal year starts from July and ends in June. I need to get details of cases which were closed in current fiscal year grouped by mont…
-
Multiple charts in one dashboardContent I'm trying to create a dashboard that has "Incidents by category" with a separate graph for each of our offices (each office is a queue). To start off, I create …Opie 36 views 1 comment 0 points Most recent by Dietrik -120086 Reporting & Analytics for B2C Service
-
Profile Permissions - Reporting on Administration Tab SelectionsContent Trying to locate the table where this info is captured to generate a report. Need to know if the options are selected or not. Thanks in advance for any feedback.…Joe P. 24 views 2 comments 0 points Most recent by Carl Elliott Reporting & Analytics for B2C Service -
Answers Not Used - Analytics Cookbook RecipeContent Answers Not Used With Starters and desert Author: Dietrik KPN Consulting Difficulty rating: (Intermediate) Target persona: Content Manager Ingredients: 4 Total R…Dietrik -120086 114 views 1 comment 5 points Most recent by Erica (Leep) Anderson Reporting & Analytics for B2C Service -
Team Open Incidents Summary (Team Dashboard) - Analytics Cookbook RecipeContent Team Open Incidents Summary (Team Dashboard) With Incident Details Report Link Author: Kenny T Oracle Service Cloud Analytics Product Manager Difficulty rating: …Kenny Tietz-23935 130 views 1 comment 6 points Most recent by Erica (Leep) Anderson Reporting & Analytics for B2C Service -
Report to check backlog in a specific date.Content Hello everybody, I'm trying to create a custom report to show the backlog of incidents in a specific date. For example, I choose a range of dates, 2016/04/01 unt…Leonardo De Souza 35 views 0 comments 0 points Most recent by Leonardo De Souza Reporting & Analytics for B2C Service
-
Hello Team, As we have multiple Relationship Item under insert control tab Like( File...Content Hello Team, As we have multiple Relationship Item under insert control tab Like( File Attachment, Log view, Audit Log, case view etc.) What I need is, when I am …Vikash Patel-123058 20 views 1 comment 0 points Most recent by Dietrik -120086 Reporting & Analytics for B2C Service
-
Custom Report returning duplicate search resultsContent Hello dears, I have created a custom incident report by copying the 'Today's Incidents' report and enabled it in my profile navigation set. The report has the sa…Hanna Abi Akl 33 views 1 comment 0 points Most recent by Hanna Abi Akl Reporting & Analytics for B2C Service -
Can we have a single report to export all the chat attributesContent Hi, We are currently in the process of migrating the chat solution from ATG to Oracle Service Cloud. Have attached the data dictionary for the existing ATG solut…Vignesh Nagarajan-126051 34 views 0 comments 0 points Most recent by Vignesh Nagarajan-126051 Reporting & Analytics for B2C Service
-
Report/Analyse CF used in WSContent Hi everyone, I hope someone can help on this. In the past we used to create custom fields (CF) for nearly everything and now it ended up in a total mess. Now we …Marcin Majcher 21 views 2 comments 0 points Most recent by Marcin Majcher Reporting & Analytics for B2C Service
-
Request assistance understanding how Incident Edit Time is greater than total time agent logged intoContent Pulling up the Agent Login Report (Report ID :54). I can see the following agent who was logged into OSC for 10h 50m 51s but Incident Edit Time is 19h 12m 41s. I…Ajay John 18 views 2 comments 0 points Most recent by Ajay John Reporting & Analytics for B2C Service
-
Average Incident Handle Time Per AgentContent I am trying to create a report in Report Explorer that indicates how long an agent took to respond to an incident email. This would be from the time the incident…William Bradford 43 views 3 comments 0 points Most recent by William Bradford Reporting & Analytics for B2C Service -
Deleting Published reportsContent Hi, We have scheduled various reports to form a published report. Over the year published reports have accumulated and taking the file space. Is there any way to…Maheep Kaur 34 views 2 comments 0 points Most recent by Dietrik -120086 Reporting & Analytics for B2C Service -
% of incidents having 1 Customer entryContent Hi, I need to show the percentage of email incidents which got solved with 1 customer email. So ideally no. of incidents with 1 customer entry in threads table. …Maheep Kaur 33 views 4 comments 0 points Most recent by Bastiaan van der Kooij Reporting & Analytics for B2C Service
-
Multiple Questions about Reporting Please Help!Content 1.) We have a client that emails us tickets on behalf of another client that is in RN. When that ticket comes in, it is assigned to Client A and it shows on beha…Donnie Guthrie 11 views 1 comment 0 points Most recent by Erica (Leep) Anderson Reporting & Analytics for B2C Service -
Report to Identify Workspace Rules per WorkspaceContent Is there a report or fields that can be used to create a report to identify specific workspaces rules and associated workspaces? I need to identify which all wor…Connie Cannon 26 views 0 comments 0 points Most recent by Connie Cannon Reporting & Analytics for B2C Service -
Daily Backlog ReportContent Using the standard Backlog Report - ID 11 This report is great and ideally what we want however I don't believe it's showing us a true backlog. The number the re…Donnie Guthrie 23 views 0 comments 1 point Most recent by Donnie Guthrie Reporting & Analytics for B2C Service
-
How to measure proactive offers stats grouped by rule name (from Engagment Engine)?Content I want to measure the effectiveness of my various rules, each of which launch Syndicated Proactive Chats (SPAC) via Engagement engine (EE). I can measure the ove…markahrens 29 views 3 comments 0 points Most recent by David Powell-119973 Reporting & Analytics for B2C Service
-
Exclude Holidays/Business HoursContent Hi Gurus, Whenever CCA team received ticket from Customer, based on the products and categories, the incident will route to corresponding Supervisor.Incident Sta…Mohana Gopal S-Oracle 19 views 2 comments 0 points Most recent by J Smith Reporting & Analytics for B2C Service -
Query Size Limitation errorContent Hi, Recently we have started facing the 'Query size limitation error' for certain reports. Even if tried to run the report with date created value(Custom Object)…Kishor C Tom 61 views 2 comments 0 points Most recent by Kishor C Tom Reporting & Analytics for B2C Service