Reporting and Analytics
Discussion List
-
Report Filters for null and not null queriesSummary: I need to be able to create a filter that if blank will return rows with that column blank, but if not blank then return rows that match the filter Content (req…Rob Shorney 83 views 1 comment 0 points Most recent by michael garverick Reporting & Analytics for B2C Service -
How do I obtain a flitered list of attachments and then export them from OSvC?Content Hello, We frequently have agents who want to create a list of attachments for specific incidents, filter for attachments that have a specific name, and then expo…Scott Heidenreich 45 views 6 comments 0 points Most recent by Scott Heidenreich Reporting & Analytics for B2C Service -
Time with agentSummary: What is the best way to calculate the time the case has been with an agent? Content (required): For example, when a client raises a case it gets assigned to an …SDP 52 views 1 comment 1 point Most recent by michael garverick Reporting & Analytics for B2C Service -
How to pull in a column full name of ctype_id=10 the main name not the representative the name =10?Summary: I have build a report and trying to pull with if(contact.ctype_id=10). I tried substring but it doesn't work, I guess I didn't make the correct combination of c…TinaB 32 views 6 comments 0 points Most recent by michael garverick Reporting & Analytics for B2C Service
-
What's the most efficient way to temporarily 'tag' records for reporting purposes?Summary: We need to check on a particular field for a large group of contacts, but have no way of querying for them. There is a separate/external and 'official' contact …Christos S. 52 views 6 comments 0 points Most recent by Christos S. Reporting & Analytics for B2C Service -
Why does Rule State double each Answer in the report?Summary: Adding Rule State to Answer Default report doubles every row for each answer. Content (required): I want to modify the Answers Default report that is a simple l…Scott Heidenreich 32 views 22 comments 1 point Most recent by Christian UoA Reporting & Analytics for B2C Service
-
How to report on a Text Formula Field in OTBISummary: A new Text Formula field will not show up in Reports and analytics, oracle manual says this is not possible but I'm curious if anyone has found a way around it.…Pete.Sterchak 32 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales
-
Incident performance data Filter Through AnaylticsResults APISummary: By Pass 10,000 records AnaylticsResults API limit Content (required): Hi Guys, The AnaylticsResults API has a limit of 10,000 records per run. We have an integr…Sylvia S. 32 views 1 comment 0 points Most recent by Robert Surujbhan-Oracle Reporting & Analytics for B2C Service
-
How to show matching incident rows from two different join tables?We're working on a project where we want to add contacts to an incident, but we can't use secondary contacts because we don't want to automatically send emails to them. …Eric Gottesman 32 views 6 comments 0 points Most recent by Justin_D Reporting & Analytics for B2C Service
-
Why are chat numbers not the same between chat report and incidents created by source (chat)?Summary: Chat Activity Report and Incidents Created by Source not showing the same numbers for live chat Content (required): If I run the Chat Activity Report and the In…MikeA 22 views 1 comment 0 points Most recent by Megan Akins-Support-Oracle Reporting & Analytics for B2C Service -
Incident Performance - some Incident records are missing on same daySummary: Hi All, I ran the report on (November 30th) at 12:15 hours with the search parameters 29-11-2022 00:00 to 30-11-2022 00:00. It resulted in 10 lines (see attachm…Seethalakshmi S 32 views 1 comment 0 points Most recent by michael garverick Reporting & Analytics for B2C Service -
Remove weekends from the report resultsHi All, I have a Queue Activity report that is a part of our Managers Dashboard. This standard report with a chart shows queue activity for the last 14 days. It consists…Pawel Strychocki 32 views 2 comments 0 points Most recent by Pawel Strychocki Reporting & Analytics for B2C Service
-
Report showing all workspaces on each workflowSummary: I have tried to create or locate a report that will show me all the workspaces (IDs included) that are assigned or listed on each workflow. I have tried to crea…David_S 32 views 4 comments 1 point Most recent by Nika Gerson Lohman Reporting & Analytics for B2C Service -
Create a transactional report that shows the latest status and the previous status updated dateSummary: Hi Community, There is a requirement to create a report which should basically identify the date the SR was set to the previous status, followed by the date the…Manjit Singh Arora-Oracle 42 views 1 comment 0 points Most recent by Nika Gerson Lohman Reporting & Analytics for B2C Service
-
Vertical line for sysdate in a Gantt chartSummary: Content (required): I'm using a Gantt chart to show the time between the start date and due date for various tasks, with the Date being the horizontal axis and …Robin Long 32 views 2 comments 0 points Most recent by Robin Long Reporting & Analytics for B2C Service
-
SLT breach AlarmsSummary: Wanted to configure a SLT breach alarms in the Incident Summary Report. Content (required): Wanted to configure a SLT breach alarms in the Incident Summary Repo…Jayashankar Lingaiah-Oracle 42 views 2 comments 0 points Most recent by Premkumar Sabarinathan-Oracle Reporting & Analytics for B2C Service
-
Table/Subject Area name which stores data for RoutinesSummary: Table name which stores data for Routines Content (required): Hi All, I need to know the base table/subject area(OTBI) which stores the information related to R…BhavikBhatti 51 views 1 comment 0 points Most recent by Premkumar Sabarinathan-Oracle Fusion Service -
Can you add a filter to the Customer Portal Search Report?Summary: Can you add a filter to the Customer Portal Search Report? Content (required): I'm looking to add a filter the search within our Customer Portal. Is there a way…kerry walker 32 views 4 comments 0 points Most recent by kerry walker Reporting & Analytics for B2C Service -
Is there a report which can tell agent used Fill my inbox to pull incidents?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Megha Nagpal 42 views 2 comments 0 points Most recent by Premkumar Sabarinathan-Oracle Reporting & Analytics for B2C Service
-
tell if notifications were sent to subscribers when an answer was updatedContent Is there a way to tell if notifications were sent to subscribers when an answer was updated? If the publisher forgot to choose from the Notify Subscribers dropdo…
-
Report time difference between a specific status and Updated.Summary: We are trying to capture the response time from a contact. We use a status of Awaiting - xxxx Response and we need to measure the time from this status to the v…Jeff Scrobel 41 views 2 comments 1 point Most recent by Jeff Scrobel Reporting & Analytics for B2C Service -
Join Accounts table with Custom Field from Contacts TableHello Admins, is there a way to join information from the Accounts table (Full Name) with a Custom Field (Term date) from the Contact Table? I've tried different ways of…Pawel Strychocki 72 views 3 comments 0 points Most recent by michael garverick Reporting & Analytics for B2C Service
-
I want to get details on which agent applied a particular status, for e.g-closed statusSummary: i want a report which can tell that in a particular incident , who applied what status, Sometimes, the assigned person is different from who applied the status.…Megha Nagpal 42 views 1 comment 0 points Most recent by michael garverick Reporting & Analytics for B2C Service
-
Schedule a CSV to an SFTP LocationSummary: Schedule a CSV to an SFTP Location Content (required): Hi guys, Is it possible to schedule a report in CSV format from Service Cloud to an SFTP location? Regard…Sylvia S. 32 views 1 comment 0 points Most recent by Premkumar Sabarinathan-Oracle Reporting & Analytics for B2C Service
-
Last user transaction dateSummary: I'd like to view agents in certain profiles and monitor their last transaction date and time--mostly used a tool to see if an agent is sitting for long periods …Vanessa Topolewski 52 views 4 comments 0 points Most recent by Vanessa Topolewski Reporting & Analytics for B2C Service
-
Tracked Links in a chatContent Any ideas on how to report on a tracked link that is added to chats. Tracked links work in mailings, surveys and some message templates but they don't appear to …Carl Elliott 31 views 2 comments 0 points Most recent by TinaB Reporting & Analytics for B2C Service -
Show report that sent by AdminSummary: Hi Guys, I know that we can schedule and send out a report. But is there any report or way to check a list of reports sent out under a specific Admin account or…Vincent Lin 32 views 2 comments 0 points Most recent by Justin_D Reporting & Analytics for B2C Service -
How you get information on whether a user is logged in or not when visiting your site?Summary: Why do the total visits number from session_summary table and the count of clickstreams created during the same time period differ? Isn't a new clickstream crea…
-
How do you get a workspace to open with the that rows records for editingSo for example the Contacts report id:124 when you run it you can click on any results row, and it will open up the Contact workspace. When i view the definition of a co…spence_abcd0109uk 32 views 3 comments 0 points Most recent by Justin_D Reporting & Analytics for B2C Service
-
Search functionality in customer portal is not workingSummary: Search functionality is used to search the incidents on the customer portal. Incident reference number is not searching and also mid keyword from the subject li…Jayashankar Lingaiah-Oracle 22 views 5 comments 0 points Most recent by Justin_D Reporting & Analytics for B2C Service