Reporting and Analytics
Discussion List
-
Report Showing All account password resetsSummary: Hi Is there any report or way to report all account passwords done in a given time frame? Content (required): Report with detail of all account passwords done b…Srinath Kannan-Oracle 23 views 1 comment 0 points Most recent by Colin Campbell-118909 Reporting & Analytics for B2C Service -
Disabled Accounts by date disabledSummary: Content (required): I'd like to put a date filter on the disabled account report so I can pull a report of all accounts that we disabled this year. I tried link…Kim Dante 21 views 1 comment 0 points Most recent by michael garverick Reporting & Analytics for B2C Service -
Report of incident after a ticket is closedSummary: To track the incidents post closure activity like reopening/ updated... Content (required): Suppose a ticket is been closed and later it got reopened. I have to…Boby B Jacob 31 views 2 comments 0 points Most recent by Boby B Jacob Reporting & Analytics for B2C Service -
Get No. of Days Open for incident Excluding Holidays in a ReportSummary Get No. of Days Open for incident until closed Excluding Holidays in a ReportContent Hi all, I have a requirement of report having a column which displays no of …Lakshay Bhalla 60 views 15 comments 0 points Most recent by KKalyan-Oracle Reporting & Analytics for B2C Service -
Add a link report to a report total calculationSummary: Add drilldown on a total count column. Content (required): I have a report that has a column count. I add a total count for the column I select from the Design …Lau 51 views 1 comment 0 points Most recent by Steve Garvert-Support-Oracle Reporting & Analytics for B2C Service
-
The selected Report Definition File is not a valid fileContent We're seeing an error "The selected Report Definition File is not a valid file exported by the Report Designer Export function, or the exported file has been mod…User_2025-02-01-08-53-02-236 50 views 9 comments 1 point Most recent by Utkarsh Dangayach-194615 Reporting & Analytics for B2C Service -
Listing Answers via report filterSummary Listing Answers via report filterContent Hello! I am trying to filter Answer IDs in a report, but the filter doesn't not seem to allow this when choosing "in lis…kerry walker 50 views 8 comments 0 points Most recent by User_3HDAP Reporting & Analytics for B2C Service -
Distinct Records in Consolidated DashboardHi, I have 2 reports with same columns & filters from different tables. I want to combine into one report. I am using Consolidated Dashboard option with distinct values …Mohana Gopal S-Oracle 34 views 1 comment 0 points Most recent by Junie Rose Bodoso-Support-Oracle Reporting & Analytics for B2C Service -
Looking for a way to run an article history from AnalyticsSummary: I am trying to create an article-history in Analytics, much like the history shown in the knowledge advanced editing-tool. Started out with creating a report ba…Marco Klomp-223061 41 views 2 comments 0 points Most recent by Marco Klomp-223061 Reporting & Analytics for B2C Service -
Turn Around Time calculation with 60/60/10.5 Extending Response TimeSummary: I'm trying to extend the response times to incidents. Not able to find anything in any forum that can assist. As example what I'm trying to accomplish here is w…
-
Incident's assigned account email addressHi, I'm using Accounts table to get the email address of the agents assigned to incidents. However, the email address being pulled per case/incident don't show the email…
-
Help with report creation to trace the queue from client on Right NowSummary: Hi! Well, I'm are trying to assemble a report in Right Now that followed the history of queues that a chat went through, containing the source and destination q…Evandro_MN 41 views 2 comments 0 points Most recent by Evandro_MN Reporting & Analytics for B2C Service -
Archived Incidents transaction reportingSummary: Reporting on Archived Incidents access usage stats using transactions table Content (required): Has anyone had success reporting on Archived Incidents access us…HelenH 61 views 3 comments 0 points Most recent by Steve Garvert-Support-Oracle Reporting & Analytics for B2C Service
-
Help with If statementSummary: Help with If statement Content (required): Hello, I'm trying to update the column of a report with this logic - If the count of the answer views is great than 1…kerry walker 91 views 10 comments 0 points Most recent by kerry walker Reporting & Analytics for B2C Service
-
Dashboard Report to pull today only closed incidentsSummary: Daily Closed with Drill Down Level Report. Trying to make it to pull only current date closed with relative since is Dashboard Report and no filter should show …
-
System Report OptimizationSummary: I have report that is prebuild (before my time). Is working in the console but not in the BUI and currently trying to find ways to rebuild or filter it to show …
-
All Incidents column showing with Multiple Duplicates inc_performance inner join incidents tablesSummary: I have two level report with a variable date_format(incidents.closed,$date_format) that groups by incident.closed. I have two reports build the same way and the…
-
Is there a report that can count no. of E-mail interactions in the communications thread?Summary: Hi Experts, Is there a report or is it possible to count the number of e-mail interactions or e-mail exchanges from the customer to the Agents? I just need the …Jepee Celorico 42 views 4 comments 0 points Most recent by Jepee Celorico Reporting & Analytics for B2C Service
-
All Incidents column showing with Multiple Duplicates inc_performance inner join incidents tablesSummary: The report consists of two levels the top level has All Incidents column: "count(incidents.closed)" that is counting incidents outside of the timeframe while th…
-
How to count different option from 3 different custom columns in CHATS ReportsSummary: Report table incidents inner join with contacts. I already added filters to show all by contact. I tried adding additional filter/s but is not letting me and th…
-
Reporting on Answers where agents have NOT createdSummary: Ability to search for Agents that have NOT created an answer. I have a report that looks at the Answers table and it has the Creator field and Year Month with a…SDP 61 views 3 comments 0 points Most recent by michael garverick Reporting & Analytics for B2C Service
-
outer join with WHERE NOT EXISTS statementContent Hi, I'm looking for a way to configure a report with an outer join and the WHERE NOT EXISTS statement (known from native SQL). Sadly I do not find a solution. Th…User_2025-02-03-17-28-17-184 50 views 14 comments 1 point Most recent by SDP Reporting & Analytics for B2C Service
-
My array for $exit_obj does not display all the dataSummary: I'm using custom script to export the data into an array, manipulate it and dump it back into the $exit_obj. However, when the data is displayed - it does not d…Jason Phillip 42 views 2 comments 0 points Most recent by Jason Phillip Reporting & Analytics for B2C Service
-
Can the note filed from the threads table be processed as a string?Summary: I have some content in the threads field, and i want to split it apart in to separate strings for a report. However every function i use says its expects a stri…spence_abcd0109uk 31 views 1 comment 1 point Most recent by michael garverick Reporting & Analytics for B2C Service
-
Help with report - answers last accessed by users in specific profileSummary: Help with report - answers last accessed by users in specific profile Content (required): Hello. I am trying to write a report that shows the last time an answe…kerry walker 71 views 5 comments 0 points Most recent by kerry walker Reporting & Analytics for B2C Service
-
Exporting incidents with attachmentsSummary: We have a requirement to export the old incidents with attachment for old customers Content (required): Can we export the incidents from old customers along wit…Jayashankar Lingaiah-Oracle 62 views 5 comments 0 points Most recent by Lisa Bright Reporting & Analytics for B2C Service
-
Report Filters for null and not null queriesSummary: I need to be able to create a filter that if blank will return rows with that column blank, but if not blank then return rows that match the filter Content (req…Rob Shorney 92 views 1 comment 0 points Most recent by michael garverick Reporting & Analytics for B2C Service -
How do I obtain a flitered list of attachments and then export them from OSvC?Content Hello, We frequently have agents who want to create a list of attachments for specific incidents, filter for attachments that have a specific name, and then expo…Scott Heidenreich 44 views 6 comments 0 points Most recent by Scott Heidenreich Reporting & Analytics for B2C Service -
Time with agentSummary: What is the best way to calculate the time the case has been with an agent? Content (required): For example, when a client raises a case it gets assigned to an …SDP 51 views 1 comment 1 point Most recent by michael garverick Reporting & Analytics for B2C Service
-
How to pull in a column full name of ctype_id=10 the main name not the representative the name =10?Summary: I have build a report and trying to pull with if(contact.ctype_id=10). I tried substring but it doesn't work, I guess I didn't make the correct combination of c…TinaB 34 views 6 comments 0 points Most recent by michael garverick Reporting & Analytics for B2C Service