Category 276
Discussion List
-
Database and File Storage report other than VCIOContent Is there a way to report on what is taking up the database and file storage? We can see in the VCIO, but want to know things like what kinds of files (Incident a…User_2025-02-03-18-13-34-376 57 views 3 comments 0 points Most recent by User_2025-01-30-19-06-33-073 Reporting & Analytics for B2C Service -
Chats reportContent Is there a report that shows for hours of the day how many agents were online vs. how many chats were active vs. how many chats were on hold? if it does not exis…User_2025-02-03-17-29-01-634 30 views 1 comment 1 point Most recent by Carl Elliott Reporting & Analytics for B2C Service
-
Proper use of count function on reportsContent I'm facing a problem while building a report . I'm trying to count the total number of chat session a client had with us. This is the report: I tried to create a…Douglas Silva 25 views 8 comments 0 points Most recent by Douglas Silva Reporting & Analytics for B2C Service -
Merging 2 text areas in a report column.Content Hi All I am trying to merge 2 text area fields into one column in a report but I am getting "expecting non-blob, found blob" error. Is what I am trying to do imp…Nigel Oliver 24 views 5 comments 2 points Most recent by Nigel Oliver Reporting & Analytics for B2C Service -
Last Referring URL Report for ChatContent Hey everyone, I am attempting to build a custom report to show the Last Referring URL before a Chat Request. I have built a "referrer" report where I used "click…User_2025-02-01-08-41-04-877 19 views 4 comments 0 points Most recent by User_2025-02-03-20-04-14-449 Reporting & Analytics for B2C Service
-
Changing size of custom fieldContent Hello, In an effort of controlling data quality, we would like to limit a custom field from 255 characters to 10. There is data currently in this field that woul…User_2025-02-03-18-55-26-007 28 views 4 comments 0 points Most recent by Geetha Amrutha Reporting & Analytics for B2C Service
-
I need help calculating with Live Chat reportsContent I am using the chat_queue_stats_rt table, it seems that it is not possible to make calculations with it. I need to have the real-time calculations of a Chat queu…User_2025-02-03-17-19-40-969 30 views 4 comments 0 points Most recent by User_2025-02-03-16-51-39-328 Reporting & Analytics for B2C Service
-
Scheduled report only had 10,000 recordContent Hello All, This is the first question on this forum as i am kind of new to Oracle Right Now CRM. i scheduled a report and i was successful in doing it however th…User_2025-02-03-19-31-37-724 39 views 2 comments 0 points Most recent by User_2025-02-03-19-31-37-724 Reporting & Analytics for B2C Service
-
Difference between user_trans and account_session_historyContent I'm doing some reporting on Staff Accounts and noticed that when I report on logins between these two tables, I get some differences. For instance, for Start Dat…User_2025-02-03-18-13-34-376 45 views 6 comments 0 points Most recent by User_2025-02-03-18-13-34-376 Reporting & Analytics for B2C Service
-
Sort Report Roll-ups by Group CountContent Is there a way to sort roll-ups by the group count? It appears that the only options that are available are to sort the roll-ups alphabetically... Alternatively,…User_2025-02-03-23-55-43-518 24 views 7 comments 0 points Most recent by User_2025-02-03-23-55-43-518 Reporting & Analytics for B2C Service
-
Default Reports on HomepageContent Hi Is there any way to set default report more than one report? I know i can add a dashboard as default. But i need to open three seperate reports as default on …Tuğçen İlke Çolak 33 views 2 comments 1 point Most recent by Gursimran Singh Saini Reporting & Analytics for B2C Service -
how do I remove the black marked area in my search report?Content Hello, how do I remove the black marked area in my search report? Thank you for your feedback. Regards, DanielUser_2025-02-03-20-43-55-510 12 views 2 comments 0 points Most recent by User_2025-02-03-20-43-55-510 Reporting & Analytics for B2C Service
-
Selecting multiple rows / sending row data to an add-inContent Hi everyone, My use case is that the agent: 1. Opens a report (and optionally uses filters) to view some/all of their help articles. 2. Selects some subset of th…Alanna Larson-116442 34 views 1 comment 1 point Most recent by Suresh Thirukoti-Oracle Reporting & Analytics for B2C Service -
String function to hide text after a characterContent Hi all. Can anyone suggest a string function that will hide part of a string after a certain character? For example: * Replace this: What I need to see - what I …User_2025-02-01-08-17-38-818 59 views 4 comments 1 point Most recent by Suresh Thirukoti-Oracle Reporting & Analytics for B2C Service
-
Changing CurrentDate format field in report headerContent Hi All Is there a way of changing the {CurrentDate} text field format from mm/dd/yyyy to dd/mm/yyyy We have tried several options but to no avail. We also tried …User_2025-02-03-19-35-06-088 25 views 3 comments 1 point Most recent by User_2025-02-03-16-51-39-328 Reporting & Analytics for B2C Service
-
Dashboard > Reports are being open in the same spaceContent I have a dashboard and around 06 reports are placed on it. Now i have configured drill downs and when i click on a drill down then the next level report is being…
-
Avoid email duplicate by Using 'GROUP BY' in Console AnalyticsContent Hi All, I have one requirement to group by the records by email.I have tried the "Group Result" functionality. If I gave only email column its working fine.Once …Seethalakshmi S 30 views 3 comments 1 point Most recent by Seethalakshmi S Reporting & Analytics for B2C Service -
Alert not sending immediatelyContent Hi, I have set up an exception on a report to alert me when a profile for staff accounts have been changed to a specific range of profiles. The alert is working …Hanna Page 34 views 2 comments 0 points Most recent by Erica (Leep) Anderson Reporting & Analytics for B2C Service -
Having a report display a queue even when there is no Incidents in the queueContent I have worked on the attached report for a couple of our clients (attached version slightly redacted) One of the objectives of the report is to list all of the q…Colin Campbell-118909 27 views 4 comments 0 points Most recent by Erica (Leep) Anderson Reporting & Analytics for B2C Service -
Custom Sorting/Ordering based on a Hidden ColumnContent Hi, I have a report based on the "chat_queue_stats_rt" table and would like to create a custom order for the displayed queues (other than alphabetical - I need s…User_2025-02-03-16-51-39-328 24 views 7 comments 1 point Most recent by Erica (Leep) Anderson Reporting & Analytics for B2C Service
-
Trying to show Last Login time for all active agentsContent I'm working on trying to put together a report that shows me all active Staff Accounts as well as each Staff Account's Last Login time. The built-in report "Staf…User_2024-12-17-19-51-10-888 73 views 5 comments 0 points Most recent by David Strong-119949 Reporting & Analytics for B2C Service
-
Calculating time spend to close an incidentContent I need to calculate the time being spent on an incident( excluding non working hours, waiting for customer etc). I followed this post:https://cloudcustomerconnec…
-
Calculating Row Wise SumContent Is it possible to have row wise Sum just like we have column wise? I could not find the right configuration method to do that. Please screenshot of my report. co…
-
Response Interval and Resolution IntervalContent I am just checking Response Interval and Resolution on the Incidents Outside Thresholds report. It is appearing as negative as in the attached snapshot. It is al…Umer 54 views 1 comment 0 points Most recent by Suresh Thirukoti-Oracle Reporting & Analytics for B2C Service
-
Edit records in Report viewContent Hi All, Can we edit the records in report view without going to the workspace view (i.e can we change the functional Area from "other " to any other value withou…User_2025-02-03-20-53-36-708 15 views 1 comment 0 points Most recent by Suresh Thirukoti-Oracle Reporting & Analytics for B2C Service
-
How to Aggregate with multiple "If expressions" using Date_GroupContent Hello - I am trying to build a "productivity" report that will give me the Count of Incidents Closed, multiplied by the Average Time it should take to close a pa…User_2025-02-03-17-08-35-376 58 views 3 comments 0 points Most recent by User_2025-02-03-17-08-35-376 Reporting & Analytics for B2C Service
-
How to access button in the report associated to child object view from parent object.Content We have a view(object1) under Asset object to which a report is associated. I need to disable the Delete button in the view based on the parent object(Asset) sta…User_2025-02-03-19-26-32-915 27 views 7 comments 2 points Most recent by User_2025-02-03-19-30-01-975 Reporting & Analytics for B2C Service
-
Answer Effectiveness - WindowContent Hi, Can anyone shed light on what the "Window" in the Answer Effectiveness report means? I'm not sure what the difference between daily/monthly/yearly is - espec…User_2025-02-03-19-49-57-702 29 views 7 comments 2 points Most recent by Shilpa Suresh-122587 Reporting & Analytics for B2C Service
-
Show First Time AssignedContent Hello I'm new to this forum so I hope this is the right place. I'm building a report for a team that shows the time spent from initial incident creation to when …User_2025-02-03-21-37-51-574 36 views 2 comments 1 point Most recent by User_2025-02-03-21-37-51-574 Reporting & Analytics for B2C Service
-
date_diff does not appear to work on dates past 01/01/1970Content Hi All, As many will know, for a long time the date and date/time fields in OSvC would not accept dates prior to 01/01/1970 due to them using UNIX time and seemi…Mike Griffiths 24 views 3 comments 2 points Most recent by User_2025-02-03-19-30-01-975 Reporting & Analytics for B2C Service