Category 276
Discussion List
-
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 40 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 37 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 19 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 86 views 23 comments 0 points Most recent by kerry walker Reporting & Analytics for B2C Service -
wrong forum, please delete.Version 18.bPavel Kartuz 36 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 38 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 216 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 47 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 61 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 50 views 3 comments 0 points Most recent by User_2025-02-03-18-10-34-197 Reporting & Analytics for B2C Service
-
Can't get LIKE operator to work if there's a spaceContent Hi I'm trying to set up an alert on a custom report to fire if the incident thread contains "customer data". I'm using the filter incidents.search_thread like %c…User_2025-02-03-20-01-45-901 49 views 5 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
Reports: The number of incident closed at first contactContent Hi All, I have an requirement to show The number of incident closed at first contact. can any one help me to do this how?Sathya Rajendran 29 views 8 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service -
Aggregate responses per incidentSummary Creating a report to show the aggregate responses per incident (RPI), but getting duplicate values and unable to group results.Content Hi all I'm attempting to c…User_2025-07-18-00-44-03-945 49 views 1 comment 2 points Most recent by D.J.C. Reporting & Analytics for B2C Service
-
How to track video views within an AnswerSummary Is their a way to track how many times a video has been viewed within an answer?Content I created an Answer on the customer portal and included 2 videos within t…Dorothy Norman 27 views 1 comment 0 points Most recent by User_2025-02-01-08-17-55-035 Reporting & Analytics for B2C Service
-
How to export multiple grid values in separate excel sheet in FR ReportSummary Export multiple grid values in excel sheet by one grid in one sheet FR ReportContent Dear All, I have created a FR report using more than 5 GRID. As per my requi…user11018780 34 views 2 comments 0 points Most recent by user11018780 Reporting & Analytics for B2C Service
-
answers viewed data from iFrame?Content Does anyone know if it's possible to collect answers viewed data from a report that runs in an iFrame? I have a situation whereby you login to site x (not an Ora…User_2025-02-01-08-46-19-550 36 views 5 comments 0 points Most recent by User_2025-01-30-19-06-33-073 Reporting & Analytics for B2C Service
-
Field that tracks customer closed incidentsContent Hello, I'm trying to report on all incidents closed by customers, what table and field stores this data? Thanks in advanced! JustinUser_2025-02-03-17-08-02-219 38 views 3 comments 0 points Most recent by JLFolkman Reporting & Analytics for B2C Service
-
Using a date prior to 1970 in REST api callSummary calling report with a date prior to 1970 failing via REST api, eror that it is not a valid date/time formatContent We have made a report that is to be called via…User_2025-02-04-06-43-57-835 35 views 0 comments 0 points Most recent by User_2025-02-04-06-43-57-835 Reporting & Analytics for B2C Service
-
Expression syntax errorSummary keep getting expression syntax errorContent Hi I an trying to get a report with the interval (day) in one column and the the individual incident queues and their…User_2025-02-01-07-02-31-666 39 views 2 comments 0 points Most recent by Justin_D Reporting & Analytics for B2C Service
-
Agents AuditContent Hi, We've been asked to produce an audit of agents creation, edits and deletions. * Profile Type * First Name * Last Name * Collar Number * Login * Attributes/Ac…User_2025-02-03-19-49-57-702 41 views 5 comments 1 point Most recent by Joe P. Reporting & Analytics for B2C Service
-
remove no value calculated rowsSummary when creating a calculated column - exclude rows that return "No Value"Content Hello, I'm creating a calculated column by searching for a substring within anothe…Scott Heidenreich 59 views 4 comments 0 points Most recent by Scott Heidenreich Reporting & Analytics for B2C Service -
Syntax/ expression guideContent Hi! Is there any guide/tutorial with examples with all the syntax and expressions available in reports? Thnx!User_2024-12-17-19-53-13-615 50 views 2 comments 0 points Most recent by User_2025-02-03-16-51-39-328 Reporting & Analytics for B2C Service
-
Drilldown level error in reportsContent Hi All, I have created a report with drilldown level.When I open the report and click the drilldown it shows as reports errors. It seems that it is an argument m…Shaheela 22 views 2 comments 0 points Most recent by User_2025-02-03-16-51-39-328 Reporting & Analytics for B2C Service -
Eliminating duplicates in a column but not rowsSummary Attempting to remove duplicates revenue values because it throws off the totalContent I'm using two custom objects that are related to each other. One object is …User_2025-02-03-18-15-20-995 47 views 3 comments 0 points Most recent by Colby Ross Reporting & Analytics for B2C Service
-
replacing image with valueContent We would like to replace the 'checkmark' in the standard 'Survey Responses by Contact' report with a value. The reason being that the checkmark is an image and w…User_2024-12-17-19-38-18-061 39 views 2 comments 1 point Most recent by User_2025-02-03-22-16-06-242 Reporting & Analytics for B2C Service
-
BUI - custom report for archived incidentsSummary Because the BUI does not allow for Archived Incidents object, need custom reportContent Has anyone come up with a solution to view the threads of an archived inc…User_2025-01-31-02-50-15-254 28 views 1 comment 0 points Most recent by User_2025-01-31-02-50-15-254 Reporting & Analytics for B2C Service