Reporting and Analytics
Discussion List
-
Multiple Duplicated for each column in report including Incidents and Threads tablesSummary: I build report with innerjoin b/w the tables incidents and threads. The report even with filters when pulled it shows multiple duplicates for each existing colu… -
Customer Log in Stats on CP pagesSummary: My customer uses multiple CP launch points but one of which involves the customer to log in to access the functionality provided by the custom objects. We have …Colin Campbell-118909 22 views 2 comments 1 point Most recent by Colin Campbell-118909 Reporting & Analytics for B2C Service -
Limit runtime dropdown choicesI'd like to limit an accounts.account_id runtime filter to only show values where the account belongs to a specific profile. We have a lot of accounts and I'm trying to …Mitch Haggman 42 views 2 comments 0 points Most recent by Mitch Haggman Reporting & Analytics for B2C Service
-
Can the service usage metrics reports be run via API and automated?Summary: Ive got anywhere from 20-30 active distinct instances and having to log into each and every one monthly to run the same report is a giant waste of time. Content…Justin_D 22 views 1 comment 0 points Most recent by Premkumar Sabarinathan-Oracle Reporting & Analytics for B2C Service -
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 21 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 22 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 21 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 51 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 42 views 1 comment 0 points Most recent by Steve Garvert-Support-Oracle Reporting & Analytics for B2C Service
-
How to track number of users visiting on any learning item (any offering) ?Summary: Hi experts, is there any way in HCM SAAS product -> Learning module , where for any offering item (any course/activity) , we can track the users who are just vi…
-
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…Jared 51 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 51 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 31 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 32 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 42 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 62 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 82 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 62 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…Erik Erbstober 41 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 41 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 32 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 72 views 5 comments 0 points Most recent by kerry walker Reporting & Analytics for B2C Service