Category 276
Discussion List
-
Aggregate functions last() is not working as expectedSummary last() should return last row of the data set, but it is fetching all the records.Content Objects : a) Incident b) CO.AuditLog (Custom Object). Joining Relations…Manish S. Dixit 55 views 3 comments 1 point Most recent by Levi Dyckman-Support-Oracle Reporting & Analytics for B2C Service
-
Report with link to attachments.Summary How do I get a report with a link to attachments for each incident?Content Hello, I have a report that shows the incident information and the attachments associa…Scott Heidenreich 143 views 9 comments 0 points Most recent by Alison-UniSA Reporting & Analytics for B2C Service
-
Incident SizeSummary How to get size of incidents?Content Hi, Is there a way to return the total size of an incident with and without file attachments through reporting? A simple rep…User_2025-02-03-21-58-25-969 39 views 2 comments 0 points Most recent by User_2025-02-03-21-58-25-969 Reporting & Analytics for B2C Service
-
Passing filter value from one to anotherSummary Passing filter value from one to anotherContent There are 2 filters one for primary branch code and another for secondary branch code. Customer want to show sing…User_2025-02-03-16-53-11-440 31 views 2 comments 0 points Most recent by User_2025-02-03-16-53-11-440 Reporting & Analytics for B2C Service
-
Disposition of Incident when Survey went outSummary What was the disposition of the incident when the survey went out?Content I am trying to find the disposition of an incident at the moment the survey went out. I…User_2025-02-01-08-26-30-444 31 views 0 comments 0 points Most recent by User_2025-02-01-08-26-30-444 Reporting & Analytics for B2C Service
-
Contact custom records - display only record with latest date or just one if date blankSummary Return single latest customer record for a contactContent Our contacts have custom records in eg. myTable. They may have none, a single, or multiple linked recor…
-
Time in statusContent For a given incident ID - what is the easiest way to show how long it has spent in each status Not status type - each statusKing Jack 30 views 2 comments 1 point Most recent by User_2025-02-03-22-07-33-802 Reporting & Analytics for B2C Service
-
Adding a Wildcard function to a Report Definition FormulaSummary I'm wanting to use an if statement in a report to search the subject title for a key word such as 'Accepted' and to return a custom value for this. Is it possibl…User_2025-02-05-15-36-42-527 54 views 2 comments 0 points Most recent by Sasi G Reporting & Analytics for B2C Service
-
Add the body of the ticket in a reportSummary I want to add the text-body of the ticket in a reportContent Hello All, I'm trying to create a report for all the tickets created in the last year that will have…Jenica Dracea 36 views 5 comments 0 points Most recent by User_2025-02-01-08-17-38-818 Reporting & Analytics for B2C Service
-
Phone search field with or without hyphensContent Many of our contact phone number have hyphens and more do not. I cannot find a solution for agent to search for a contact by phone number without them needing to…User_2025-02-03-19-05-39-651 53 views 4 comments 0 points Most recent by InSinkErator Reporting & Analytics for B2C Service
-
Incidents report with Answers SummarySummary Creating a report joinning two tables with no common fieldsContent Hello! I can´t find a way to add the title of an answer (answers.summary) into the incident's …User_2025-02-06-21-26-19-557 32 views 6 comments 0 points Most recent by User_2025-02-06-21-26-19-557 Reporting & Analytics for B2C Service
-
Returning More than 10k Records on Scheduled ReportContent All, We have a report that runs every night that displays new records created in one of our custom objects in the past 24hrs. This report emails itself to a hand…
-
Emails Received - Exclude Client Response to Auto Reply and Thank You ResponsesSummary Exclude Client Responses to Auto Replies and "thank you" responses to solved incidentsContent I am trying to update the Emails Received report to count the numbe…User_2025-02-07-10-02-12-918 35 views 0 comments 0 points Most recent by User_2025-02-07-10-02-12-918 Reporting & Analytics for B2C Service
-
Setting up multiple reporting schedules for different time periods within the same day.Summary Unable to change VRL_HARD limit, needing a workaround.Content Hi, I need to craft several reporting workarounds to report on previous days data via scheduled run…User_2025-02-05-08-03-16-850 23 views 6 comments 1 point Most recent by Tushar G Reporting & Analytics for B2C Service
-
Events at same second sorting incorrectly. Any way to go smaller than seconds in date_format?Content Hi, I've found when reporting on the chat_events table & sorting output by chat_events.created that two posts with the same second can be shown out of order. The…User_2025-02-03-20-01-45-901 19 views 2 comments 0 points Most recent by User_2025-02-03-20-01-45-901 Reporting & Analytics for B2C Service
-
Forward reports using non-default mailboxSummary Looking for a way to optionally forward analytics reports from a mailbox other than the default for that interfaceContent Being able to send specific types of re…Jared Terry 34 views 1 comment 1 point Most recent by User_2025-02-01-08-46-19-550 Reporting & Analytics for B2C Service
-
Catch/close "redundant" incidents that solve themselves?Summary Any ideas to recognize Incidents after customer reports issue is resolved?Content Hi All - in ecommerce, a large source of customer incidents is "Where's my orde…
-
Emailed Report ErrorSummary Scheduled report sending Excel opens with warningContent Hi all, We have a really simple report that is scheduled to run once daily. The report contains only 3 c…
-
Best Practice Guide - How to Improve Reporting Performance in Oracle Service CloudContent Attached to this post is a revised best practices document that specifically deals in optimizations and report performance within Oracle Service Cloud. Included …Kenny Tietz-23935 532 views 8 comments 29 points Most recent by Adam Liu Reporting & Analytics for B2C Service
-
Report Editor, Home > Records is not showing custom tableSummary Connected workspace opens for one report but not for anotherContent On a report A when you double click the record it opens a workspace for the connected custom …
-
Report: Queue-Change - Exclude resolved IncidentsSummary Hey @ all. I'm still creating a report to get the correct count of incidents which leaves a queue unresolvedContent Hey @ all. i wanna show my Managers what happ…User_2025-02-07-09-56-35-224 32 views 4 comments 1 point Most recent by User_2025-02-07-09-56-35-224 Reporting & Analytics for B2C Service
-
Show Percentages of crosstab column Total?Summary Need help creating a view that show trending over time (daily, weekly etc) in the % split of our Product IDs..Content I know this is possible but seem to be unab…
-
Creating a custom report with a date range in the outputSummary 1-6 days passed SLA, 7-10 Days passed SLA, 11-14 Days and 15 or greaterContent Hi friends, I am trying to create a report with incident data where I am checking …NJ 44 views 3 comments 0 points Most recent by User_2025-02-03-17-31-49-785 Reporting & Analytics for B2C Service
-
Schedule a half month reportSummary schedule a report that shows 16th to end of monthContent Hi, does anyone have an idea if it is possible to schedule a report based on hard-set half month? So the…User_2025-02-03-16-51-39-328 31 views 0 comments 0 points Most recent by User_2025-02-03-16-51-39-328 Reporting & Analytics for B2C Service
-
Passing filter value to search report dynamically from workspaceSummary Passing filter value to search report dynamically from workspaceContent when we open a search report from a workspace, i want to pass a filter value dynamically,…SumanB 54 views 1 comment 0 points Most recent by Suresh Thirukoti-Oracle Reporting & Analytics for B2C Service
-
Exceptions don't work after the script processing has runContent How do I make exceptions work when I have a custom script processing the rows? Should it still work because I can't make it work So let's say I have a column tha…King Jack 61 views 0 comments 1 point Most recent by King Jack Reporting & Analytics for B2C Service
-
date_add but only weekdaysSummary Want to use date_add, but only using weekdaysContent We have a variable that adds different numbers of days to the created date depending on the category to give…Ineke Clewer 35 views 0 comments 0 points Most recent by Ineke Clewer Reporting & Analytics for B2C Service
-
Saved Prompt Values not working (Apply Saved Customizations)Summary Need ability to have individual users review Analysis based on their prompt value selections and be able to save those values so they don't have to make prompt s…Brannon B 30 views 1 comment 0 points Most recent by Just Rhianna Reporting & Analytics for B2C Service
-
group search resultsSummary OKA I try to make a grouping of results by date and IDContent Hi, for an OKA customer im working on a report that groups searches by contact iD, by datetime. I g…Sjoerd Spring in 't Veld-145555 33 views 0 comments 0 points Most recent by Sjoerd Spring in 't Veld-145555 Reporting & Analytics for B2C Service
-
Report join should display info from Primary & Secondary tableSummary Report join should display info from Primary & Secondary tableContent I have contact table with primary employment detail and custom object secondary employment …User_2025-02-03-16-53-11-440 35 views 4 comments 0 points Most recent by User_2025-02-03-16-53-11-440 Reporting & Analytics for B2C Service