Reporting and Analytics
Discussion List
-
Esccalation reportContent Hello Guys, I have to create a report showing all the mail:to & mail:cc recipients for each level of escalation(Escalation Level1 & Escalation Level2) done in an…Jaymin kansara 44 views 5 comments 0 points Most recent by Gursimran Singh Saini Reporting & Analytics for B2C Service -
Incident ReportContent Hello, I have an incident report in which which we used filter status_id, which includes incidents with all the statuses. But we need the incidents with all the …Jaymin kansara 52 views 3 comments 0 points Most recent by Ajay Yadav-140866 Reporting & Analytics for B2C Service
-
Logged in agent flag/attributeSummary Can the logged in agent flag/attribute be used in an expressionContent Hi all. While I'm pretty sure the answer is No, I do hope to be proven wrong here Can we r…Sebastiaan Draaisma-122509 65 views 4 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service -
Group time taken/differenceContent Hi, I want to group time differences on actions... so sort of like an SLA, but it's comparing the time between an internal escalation and a response sent... So I…User_2025-02-01-07-03-13-295 66 views 5 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service -
Fetch all Reports having run as report a Staff account in Report SchedulesSummary Fetch all Reports having run as report a Staff account in Report SchedulesContent Hi, I would like to find out all the report schedules where Run Report As = 'So…User_2025-02-03-22-07-33-802 23 views 6 comments 2 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
Time in Status Report Duration Time FormatSummary How to change duration from 00h 00m 00s to HH:MM:SSContent Hi I'd like to modify the Time in Status report in the Analytics Cookbook to show the duration in HH:M…User_2025-02-03-16-15-03-850 36 views 3 comments 0 points Most recent by User_2025-02-03-16-15-03-850 Reporting & Analytics for B2C Service
-
Keyword searches by usersSummary Keyword searches by usersContent Hi, We use the keyword search table to see what keywords return no results. For some words that are strange we see a lot of entr…User_2025-02-01-07-03-13-295 39 views 1 comment 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
Incident count is not date specificSummary Incident created on a particular date with respect to incoming mailboxesContent Hi, I am creating a report for count i.e. Count of Incidents created on a particu…Ashutosh_86 29 views 4 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service -
How to make a report on the configbase_values tableContent Hi All, I recently started working on existing site, before starting this i would like to understand their current configuration settings, i can see there is con…Ajay Yadav-140866 24 views 7 comments 0 points Most recent by Ajay Yadav-140866 Reporting & Analytics for B2C Service -
Chat Concurrency Factor - 30 min intervalsContent Hello How would I edit the Chat Concurrency Factor (3015) to be broken down in intervals of 30 minutes instead of an average of the entire day?Hanna Page 41 views 6 comments 1 point Most recent by Ajay Yadav-140866 Reporting & Analytics for B2C Service -
Display order - 10 answers to be top alwaysSummary Display order - 10 answers to be top alwaysContent Report displays answers based on ID (Descending order, latest first). Customer has given 10 answers ID's and t…User_2025-02-03-16-53-11-440 32 views 4 comments 0 points Most recent by Carl Elliott Reporting & Analytics for B2C Service
-
Understanding Percentage ValueSummary Percentage Value of Reports GeneratedContent Hi Experts, I need help in understanding the reports generated from OSvC. I made a report (Status Report) I just wan…Jepee Celorico 40 views 8 comments 0 points Most recent by Ajay Yadav-140866 Reporting & Analytics for B2C Service
-
Cross instance reportingSummary Report on data from other instanceContent Hi there. Does anyone have a sample script/report/instructions for me to report on an interface residing in another ins…Sebastiaan Draaisma-122509 34 views 2 comments 3 points Most recent by Gursimran Singh Saini Reporting & Analytics for B2C Service
-
Organization Phone # Look UpContent Hi - I am importing a large list of organizations over that could have multiple phone numbers tied to one org. I have created custom fields for these (ex: ph, al…Hanna Page 29 views 6 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
Report to show search textSummary Report to show search textContent Hi How do I create report to show what is being searched in the search box? Is there any standard report available?User_2025-02-03-16-53-11-440 50 views 10 comments 0 points Most recent by Ajay Yadav-140866 Reporting & Analytics for B2C Service
-
Chat Occupancy By HourContent I'm able to create an occupancy report by date and by agent. Before I get too involved creating a formula, does anyone have a template that can report on occupan…Marv Ferrer 32 views 6 comments 0 points Most recent by Ajay Yadav-140866 Reporting & Analytics for B2C Service -
Show Warning Message in ReportSummary Show Warning Message in ReportContent I want show following warning message in my report. I don't want to add any fields into the report. "WARNING! You have logg…User_2025-02-03-16-53-11-440 43 views 18 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
Interval based reportSummary Number of incidents in every 30 minutes for a day.Content Hi, I have a query related to number of incidents created in every 30 minutes but what I can see in doc…Ashutosh_86 59 views 3 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
Display Number as Number in Excel output of BI publisher reportSummary Display Number as Number in Excel output of BI publisher reportContent I have a report which displays employee ids as part of the report. Now when I export that …User_DYMHE 31 views 1 comment 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
How to use both SUM and COUNTContent Hi, We have custom field for a contact called department. It's in the format: DEPARTMENT.TEAM I've split this successfully into two columns. The 3rd column does …King Jack 63 views 5 comments 1 point Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service -
account_session_history tableSummary How long is data kept in the account_session_history table?Content Anyone know how long the data is kept in the account_session_history table? Specifically looki… -
Is it possible to show the Report Definition as a report column?Summary Output the report definition as a columnContent I have a report that shows information about reports, such as the Report ID (name), ACID, Owner, Last Run, etc. I…Ken Sands 43 views 4 comments 1 point Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
Report on Report FiltersContent Hi, Is it possible to build a report which shows all the reports and what report filters are used in those reports? Report Link Run Values (ac_rpt_link_run_vals)…User_2025-02-03-17-15-23-653 48 views 2 comments 1 point Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
creating historical reports independent of individual column dataContent While creating a report that relies on more than one date column (incidents.created and incidents.closed) to calculate backlog, it didn't appear possible to perf…Edgardo Lineros-Oracle 51 views 5 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service
-
Need to expose the executive dashboards on Sales home pageSummary Need to expose the executive dashboards on Sales home pageContent We have developed an excutuve dashboard to contain 6 BI reports for the upper management users.…
-
Cost - Item Cost Real Time subject area refresh questionSummary How long it will take to refresh the data in the real time subject areasContent Hi Team, i would like to know how the real time subject areas will refresh. The r…User_2025-01-30-01-18-25-142 43 views 1 comment 2 points Most recent by Amarnath Govindu Reporting and Analytics for SCM
-
contracts approval flow tabelSummary tabel behind the contracts approval history flowContent Hello all, I have to build a report that contains the contracts approval flow information, like in the im…User_2025-02-04-08-34-10-102 40 views 5 comments 0 points Most recent by User_2025-02-04-08-34-10-102 Reporting & Analytics for B2C Service
-
How to check syndicate chat performanceContent Hi, i am working to get all the pages from where Chat Initiated, we are using Conditional Chat and Proactive Chat both. Columns are required : URL from where cha…Ajay Yadav-140866 32 views 1 comment 0 points Most recent by Ajay Yadav-140866 Reporting & Analytics for B2C Service
-
one report as input for another (similar to SQL View)Content Hi all, I have the following challenge: I want to use one report with a group count (e.g. first name, last name, email) to put a count behind, then do a group fi…Kai-Uwe 23 views 4 comments 0 points Most recent by Sebastiaan Draaisma-122509 Reporting & Analytics for B2C Service