Functions
Discussion List
-
Report Incident Grouping by Servicing TimeHi all. I have a report that groups incident by servicing time (using the inc_performance table and appropriate interval type filter). Using the formula if(inc_performan…Lucas Zuzarte 16 views 4 comments 0 points Most recent by Lucas Zuzarte Reporting & Analytics for B2C Service -
Can we change report standard date format using date_formatSummary: Hi We are trying to change the standard way of displaying date i.e. 09/26/2023 10:27 AM EDT in the report analytics the same way we have in CP or in Connect Obj…Baljeet Singh-231094 22 views 3 comments 0 points Most recent by Rasheed Ahamed Reporting & Analytics for B2C Service -
count multiple customer replies in a rowSummary: I am trying to make a report column that displays the LATEST count of customer replies. Content (required): The aim of the report column is to see if incidents …SDP 12 views 1 comment 0 points Most recent by Steve Garvert-Support-Oracle Reporting & Analytics for B2C Service
-
How to remove link from two level report?Summary: Two reports with slightly different definition: the first is one level 'Report Definition One Level' and the second report has two levels 'Report Definition v3'…TinaB 2 views 1 comment 0 points Most recent by michael garverick Reporting & Analytics for B2C Service
-
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…
-
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…
-
Mailing Name and Document Links with Attachment Report not showing in the BUI?Summary: I build new Outreach Report for Representatives to view in a workspace in the BUI. I'm using the mailings table with the rest. For some reason the inner join pu…
-
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 …
-
Remove Closed Incidents from Report ViewSummary: I have added report, where representative closes the incident, but the incidents stays in the report and is visible. Is it possible to remove the incident from …
-
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…
-
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 can i have todays date in Oracle broadcast emailSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Megha Nagpal 32 views 2 comments 0 points Most recent by Justin_D Reporting & Analytics for B2C Service
-
how to calculate time between interactions created date and response date?Summary: I want to know how many incidents are yet to be responded. for e.g we have SLA of 24 hours to respond. So how can i fetch a report which states that these incid…Megha Nagpal 22 views 2 comments 0 points Most recent by michael garverick Reporting & Analytics for B2C Service