Reporting and Analytics
Discussion List
-
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 27 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 29 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 38 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 44 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 22 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 32 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 11 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 31 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 57 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 32 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 33 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 26 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 32 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 14 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 28 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 23 views 3 comments 2 points Most recent by User_2025-02-03-19-30-01-975 Reporting & Analytics for B2C Service -
Auto Increment Date VariableContent Hi all, Was curious if there was a way we can auto increment a date variable - say hours - to show all increments, regardless of whether there is data for that i…User_2025-02-03-18-58-51-486 30 views 4 comments 0 points Most recent by User_2025-02-03-19-30-01-975 Reporting & Analytics for B2C Service
-
add link to workspaceContent Hello, is there a possibility to add a link to a workspace? The url behind the link consists of three parts, for example: https://aaaaaa.com/bbbb/ccccdddd/eeeee …User_2025-02-03-20-43-55-510 12 views 2 comments 0 points Most recent by Suresh Thirukoti-Oracle Reporting & Analytics for B2C Service
-
How to report on Historic Queue stats.?Content I have a report that shows the number of open incidents in all queues (attached). I would like to get the same report to show me the same data but at a specific …User_2025-02-03-16-51-39-328 17 views 3 comments 0 points Most recent by Suresh Thirukoti-Oracle Reporting & Analytics for B2C Service
-
calculate running balance?Content I'm trying to get a report to compile a running balance. I have custom fields to capture all the data, and I know I need a custom script for the calculation, but…User_2025-02-01-08-46-19-550 61 views 19 comments 2 points Most recent by User_2025-02-01-08-46-19-550 Reporting & Analytics for B2C Service
-
Count of ans_stats.hits including 0Content I'm making a report to count the ans_stats.hits for all answers in a given time period. I have an outer join on answers and ans_stats and the only filter is on d…User_2025-02-03-18-13-34-376 33 views 4 comments 0 points Most recent by User_2025-02-03-16-51-39-328 Reporting & Analytics for B2C Service