Category 276
Discussion List
-
Calculate Business Days in Oracle Service CloudSummary Please show the best way to calculate business days in OSCContent Does anyone have a formula to calculate business days in OSC reports? I want to calculate the d…User_2025-02-03-22-22-04-189 40 views 7 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service -
Answers Hit Count is not consistentSummary Answers Hit Count is not consistentContent There is complaining from customer stating that answers hit count is not consistent. We have 2 interfaces (Interface1 …User_2025-02-03-16-53-11-440 45 views 1 comment 0 points Most recent by User_2025-02-01-08-17-55-035 Reporting & Analytics for B2C Service
-
Transaction table edit timesContent Hi, We are using the transaction table to check the time spent by an agent in editing incidents. For that we are calculating the time difference between start da…Federico Palacios-Oracle 41 views 7 comments 0 points Most recent by Chuck Udzinski Reporting & Analytics for B2C Service -
Reports with linksSummary Reports with linksContent Hello, We're scheduling the Keyword Search report but noticed that the email attachments don't have clickable links (which show a speci…kerry walker 68 views 27 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service -
Report filtering by creating a drop down menu options based on predetermined filter of reportContent Hello Service Cloud Community, We are trying to make our reports a lot more user-friendly since most of the custom objects contain text fields which are hard to …Chris Vasileski 61 views 0 comments 0 points Most recent by Chris Vasileski Reporting & Analytics for B2C Service
-
Schedule on Report GoneSummary Schedule on Report GoneContent Hi Experts, I have configured a report that will automatically send the result every month but when I checked it again, it's gone.…Jepee Celorico 52 views 7 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
Get URL variable in a custom script reportingSummary Modify URL in the report data cellContent Hi, I've been reading about custom script in the report. I followed through online documentation, a few of posts from t…Win Moe-118858 46 views 4 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
Report Date Range FilterContent Hi, When I apply Date filter to show data of previous week only, the calculations automatically gets multiply by 5 (See screenshot). Without filter it shows corr…User_2025-02-03-20-08-55-527 95 views 17 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
Dashboard Report showing no dataContent Hello, When there is no incident on specific dates, nothing is shown on report. It should at least show report with empty data. My other reports at least show em…User_2025-02-03-20-08-55-527 49 views 14 comments 0 points Most recent by User_2025-02-03-20-08-55-527 Reporting & Analytics for B2C Service
-
.Summary .Content .Sebastiaan Draaisma-122509 25 views 0 comments 1 point Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service -
Task report - who last updated?Summary Identify agent that last updated a taskContent Hi all. Is it possible to identify in a TASK report who last updated? Scenario - The task is assigned to an Agent,…User_2025-02-01-08-17-38-818 39 views 5 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
Average calculation using date_diff at summary level vs. report calculationsSummary The average date_diff calculation, used at the summary level, includes cases with a null date value, distorting the totalsContent I've built two reports (definit…User_2025-02-03-16-13-34-099 20 views 5 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
What Is Attribute 4 (id4)?Summary What value is contained in the transactions.id4 column?Content We have created an analytics report for the transactions table that outputs the transactions.id4 c…Skyler Niedrist 46 views 5 comments 0 points Most recent by Skyler Niedrist Reporting & Analytics for B2C Service
-
Report with Column Description and Data TypeSummary Looking for a way to create / download a report that lists Table Elements with Column Descriptions and Data TypesContent Is there a way i can create a report and…User_2025-02-03-20-29-17-872 44 views 3 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
Creating relationships with OFS dataSummary we want to create relationships with integrated data from OFS which all comes in via text fieldsContent Hi all, First forum post so please be kind if this is an …Kris Cartwright 43 views 0 comments 0 points Most recent by Kris Cartwright Reporting & Analytics for B2C Service -
Filters in Custom ReportSummary Assigning Filter values dynamicallyContent Hi, We have a requirement where we need to pre assign the values in the docked filters of a report based on few condit…Padma Prabha Varadarajan-135182 55 views 5 comments 0 points Most recent by Padma Prabha Varadarajan-135182 Reporting & Analytics for B2C Service
-
Value of field substr of text in thread - if, then, else statementSummary Issues with definition of a column of data with some conditions in it.Content I have a report that was pulling data out of the thread to define a column. That in…User_2025-01-31-02-50-15-254 39 views 4 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
Automatically Open a Report on WorkspaceContent Hi Experts, I have an inquiry if it is possible to open a report on a workspace with the same Reference Number with the service request opened. For example, I ha…Jepee Celorico 36 views 38 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
Show list of custom fields created by a certain account?Content If I want to know what custom fields have been created by a particular account (this value can either be hardcoded or supplied as filter), what tables will I hav…Nisar 28 views 6 comments 2 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service -
Incident Summary SearchSummary How to exclude Auto Responses and SmartAssistant in search resultsContent We have created reports to search by incidents.search_thread , however this seems to se…Tod 71 views 3 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
Report styling tip for row numberSummary A styling tip to get your row number match other stylesContent This is just a styling tip that I would like to share on how to get a row number to match your rep…Sebastiaan Draaisma-122509 37 views 3 comments 4 points Most recent by User_2025-02-01-08-17-55-035 Reporting & Analytics for B2C Service
-
Users that have not logged inSummary Tracking users that have not logged into the OSvC ClientContent Hello, I'm trying to create a simple report that will show a user's name and whether or not they'…kerry walker 85 views 23 comments 0 points Most recent by kerry walker Reporting & Analytics for B2C Service
-
wrong forum, please delete.Version 18.bPavel Kartuz 34 views 0 comments 0 points Most recent by Pavel Kartuz Reporting & Analytics for B2C Service
-
Disable Add New optionSummary Disable Add New optionContent I have report linked to contact workspace tab.(Ref Screen Shot below) I want disable "Add new" option if report contains one record…User_2025-02-03-16-53-11-440 37 views 1 comment 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
How to remove the ".invalid" from email signatureSummary email signatureContent I would like to find way to remove the '.invalid' in the email signature for the contacts. Help Any one?User_2025-02-03-21-27-12-392 28 views 2 comments 0 points Most recent by User_2025-09-05-00-11-37-622 Reporting & Analytics for B2C Service
-
Expired vs. Cancelled ChatsSummary Which is the calculated abandoned rate?Content Can anyone advise on What is the industry standard to calculate the abandoned chat rate? Do we include the expired…Dorothy Norman 20 views 1 comment 1 point Most recent by User_2025-02-03-16-51-39-328 Reporting & Analytics for B2C Service -
A 'How to' on using regular expressions in custom scripts for GDPRContent GDPR, how to find sensitive data in a report using regular expressions in custom scripts. This is a how to for those new to reporting and custom scripts :-) Cust…Sebastiaan Draaisma-122509 215 views 9 comments 22 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
Total of Incidents last updated by customerSummary Total of Incidents last updated by customerContent Hello, I'm using this formula to indicate whether a customer last updated an incident: substr(max(concat(date_…User_2025-02-03-21-48-33-357 46 views 2 comments 0 points Most recent by User_2025-02-03-21-48-33-357 Reporting & Analytics for B2C Service
-
Logged In/ Logged outContent Hi, I have a report that I am trying to add to it an exception that if the assigned account is logged out then highlight in red. I have found many posts here tha…User_2025-02-03-18-10-34-197 59 views 11 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
Report exception if staff account is not logged inContent Hi all, I am looking for a little help with an existing report. So I have a basic report which shows the following: Staff Member (incidents.assgn_acct_id) Overdu…User_2025-02-01-08-29-25-648 55 views 3 comments 0 points Most recent by User_2025-02-03-18-10-34-197 Reporting & Analytics for B2C Service