Category 276
Discussion List
-
Is there a report that can count no. of E-mail interactions in the communications thread?Summary: Hi Experts, Is there a report or is it possible to count the number of e-mail interactions or e-mail exchanges from the customer to the Agents? I just need the …Jepee Celorico 41 views 4 comments 0 points Most recent by Jepee Celorico Reporting & Analytics for B2C Service -
All Incidents column showing with Multiple Duplicates inc_performance inner join incidents tablesSummary: The report consists of two levels the top level has All Incidents column: "count(incidents.closed)" that is counting incidents outside of the timeframe while th…
-
How to count different option from 3 different custom columns in CHATS ReportsSummary: Report table incidents inner join with contacts. I already added filters to show all by contact. I tried adding additional filter/s but is not letting me and th…
-
Variable based on Employee logged inSummary: We believe we need to use a variable based on who is logged in to the system so we can detemine the type of work Content (required): A team wants to use Tasks a…Jeff Scrobel 22 views 1 comment 0 points Most recent by Steve Garvert-Support-Oracle Reporting & Analytics for B2C Service -
how can i have todays date in Oracle broadcast emailSummary: 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 31 views 2 comments 0 points Most recent by Justin_D Reporting & Analytics for B2C Service
-
Reporting on Answers where agents have NOT createdSummary: Ability to search for Agents that have NOT created an answer. I have a report that looks at the Answers table and it has the Creator field and Year Month with a…SDP 62 views 3 comments 0 points Most recent by michael garverick Reporting & Analytics for B2C Service
-
My Queued ReportsSummary: I have a report that are stuck in Processing state, so I beleive this is stopping me from running this report again. Content (required): How can I delete the re…Jeff Scrobel 51 views 1 comment 0 points Most recent by Anuj Behl Reporting & Analytics for B2C Service
-
outer join with WHERE NOT EXISTS statementContent Hi, I'm looking for a way to configure a report with an outer join and the WHERE NOT EXISTS statement (known from native SQL). Sadly I do not find a solution. Th…Erik Erbstober 50 views 14 comments 1 point Most recent by SDP Reporting & Analytics for B2C Service
-
My array for $exit_obj does not display all the dataSummary: I'm using custom script to export the data into an array, manipulate it and dump it back into the $exit_obj. However, when the data is displayed - it does not d…Jason Phillip 41 views 2 comments 0 points Most recent by Jason Phillip Reporting & Analytics for B2C Service
-
Can the note filed from the threads table be processed as a string?Summary: I have some content in the threads field, and i want to split it apart in to separate strings for a report. However every function i use says its expects a stri…spence_abcd0109uk 31 views 1 comment 1 point Most recent by michael garverick Reporting & Analytics for B2C Service
-
Help with report - answers last accessed by users in specific profileSummary: Help with report - answers last accessed by users in specific profile Content (required): Hello. I am trying to write a report that shows the last time an answe…kerry walker 74 views 5 comments 0 points Most recent by kerry walker Reporting & Analytics for B2C Service -
Exporting incidents with attachmentsSummary: We have a requirement to export the old incidents with attachment for old customers Content (required): Can we export the incidents from old customers along wit…Jayashankar Lingaiah-Oracle 64 views 5 comments 0 points Most recent by Lisa Bright Reporting & Analytics for B2C Service
-
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 93 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 48 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 31 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 41 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 76 views 1 comment 1 point 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. 31 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 41 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 21 views 1 comment 0 points Most recent by Megan Akins-Support-Oracle Reporting & Analytics for B2C Service -
Administrator Assigned Agent as Docked Filter for existing report: What table and how to?Summary:I added to a column after I have join the tables in a report and in a type column I added as filter: first(accounts.display_name, transactions.created). I also a…
-
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 31 views 1 comment 0 points Most recent by michael garverick Reporting & Analytics for B2C Service -
Dashboard- show when an incident has reached a percentage of SLASummary: We are looking at changing a dashboard to show when a response has not been given at a certain percentage of the SLA Content (required): The Dashboard will high…KaneC 51 views 1 comment 0 points Most recent by Megan Akins-Support-Oracle 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 42 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 31 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 41 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 52 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 41 views 2 comments 0 points Most recent by Premkumar Sabarinathan-Oracle Reporting & Analytics for B2C Service