To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting & Analytics for B2C Service
Discussion List
-
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 …
-
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
-
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,…
-
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…
-
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…
-
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…
-
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
-
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
-
Report including Incident created, status changed and previous status changed date columnsSummary Help required with Custom Script to enable date in status reporting requirementContent Hi, 1. I have built a report that uses the Incidents table to get the refe…
-
how to get the number of chats by siteContent We offer customers to start chat from customer Portal and brand website (by CCL link), i would like to identify how many chat coming from our custhelp pages and …
-
Show corresponding filter valueSummary Show corresponding filter valueContent Hi, I have 2 filters ID & Name. User filter the report either by ID or Name. I show filter value in text item ((filter nam…
-
How to show decimal places in 'average' column calculation?Summary Using the 'average' calculation is rounding, and I don't want it to.Content Hi everyone, I am trying to use "Edit Calculations" on a report column to get an aver…
-
Changing date in report column from dd/mm/yyyy to dd/mm/yySummary Change from 4 digit year to 2 digit yearContent In Edit Definition I have tried date_format(fieldname,'DDMMYY') but it stopped showing the date and just repeated…
-
Date group formatting by week.Content Hi, I am grouping data into reporting weeks by using the syntax below: date_format(transactions.created,'Week: WW MONTH YY'). This is displayed as "Week: 34 Augu…
-
Filter "To" Email Addresses in Forward IncidentSummary Filter "To" Email Addresses in Forward IncidentContent Is it possible to filter the list of email addresses that are displayed when forwarding an incident? For e…
-
Difference between Duration and Total PeriodSummary Difference between Duration and Total PeriodContent Hello, Can you help me understand the difference between Chat duration defined as if(chats.state=5, date_diff…User_2025-02-03-17-38-42-482 32 views 3 comments 0 points Most recent by User_2025-02-03-17-38-42-482
-
Remove field in exported reportSummary Remove fields in exported reportContent I have 4 fields in my report. When I export the report, I want remove 1 fields and show 3 fields in the exported report.(…User_2025-02-03-16-53-11-440 17 views 3 comments 0 points Most recent by Levi Dyckman-Support-Oracle
-
Removal of duplicate emails for a contactSummary Script to remove emails with .00XXContent Hi All, I've added the below script in one of my report to delete duplicate emails Scenario: email_alt1 is valid and em…User_2025-02-04-23-27-31-855 95 views 1 comment 0 points Most recent by User_2025-02-04-23-27-31-855
-
Sort Incident Menu Custom FieldSummary Sort by Menu Order Option DisabledContent Hey all, I have a custom field in Incidents that is of the menu datatype and the menu items are being pulled from a men…
-
Proactive Chat Offer Statistics #3033Content Is there a way to filter Proactive Chat Offer Statistics #3033 to show the originating webpage? I know how to distinguish the page using a custom field once an i…
-
Problem with adding Custom Reports on Report DashboardContent Hello I'm using February 2016, and I've been trying to add two custom reports on Report Dashboard, referring to the following Answer; https://cx.rightnow.com/app…
-
Report based on Virtual Table- Real time data update and Current Record ContextSummary Updates to External Data report based on Virtual TableContent Good Day, Can we fetch the current record context from a report based on virtual table (external da…
-
Report Needs to Include Updated Messages, New Messages and %s and Real TimeSummary Updated Messages, New Messages and %s Percentages for queues - Real TimeContent I'm trying to develop a report that will give the 'Queues' current volume, volume…User_2025-02-01-07-43-22-355 30 views 0 comments 0 points Most recent by User_2025-02-01-07-43-22-355
-
Embedded URL ReportSummary How to show the file path of the attached file in an incidentContent Hi Everyone, I've working in my reports and i was able to show the attachments on each incid…
-
Real Time Reporting - Incidents Received, Resolved, Longest time in QueueSummary Real Time Reporting - Incidents Received, Resolved, Longest time in QueueContent We've been tasked with creating Real Time Reporting (or as close to real time as…
-
Reports Alignment on DashboardContent Hello, Can someone please share tips for aligning reports on dashboard? i have tried multiple ways but it's really annoying to just fit all reports without scrol…
-
Interval Type - Menu DescriptionsSummary Looking for full descriptions for menu itemsContent Hi. I'm looking for a published list with FULL descriptions/example for each of the Menu Items under Interval…
-
How to remove the highlight on the first line of a reportContent There may be an obvious answer to this petty annoyance.. but here goes...! I have some nice reports with exceptions that colour lines of data based on service le…
-
First call resolution report (Basic)Content Hello everyone, I'm trying to write a report which will show me in very basic terms the first call resolution. To do this I want to create a report with three co…