To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting & Analytics for B2C Service
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 56 views 3 comments 0 points Most recent by User_2025-01-30-19-06-33-073 -
Combining results from tables that are joined multiple timesContent Hi, When I join the same table twice using different conditions, both conditions give different results. The agents may satisfy any one or both the conditions. I… -
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…
-
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
-
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
-
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 … -
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… -
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
-
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
-
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 … -
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 …
-
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
-
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 …
-
FontsContent Does anyone have a text file of the fonts available from the styles explorer? I really don't want to type them all out for a tender response... Thanks! Mark -
Drilldown level error in reportsContent Hi All, I have created a report with drilldown level.When I open the report and click the drilldown it shows as reports errors. It seems that it is an argument m… -
Report filters in BUIContent Hello, I have configured queue report (which is copy of standard queues) report. There is one filter on this report which filter out queue values which are only … -
Audio Alert on Reports (Exceptions)Content Hi, Is it possible to have an exception give an audio alert? In my case, I was asked if we can provide one for a report we use for Live Chat Monitoring. Basicall…
-
Calculate target date from another date (excluding weekends and holidays)Content Hi, I have a requirement to show a 'target date' based on a custom date/time field. This is basically showing the target for a given team to deal with an inciden…User_2025-02-03-17-31-49-785 28 views 41 comments 0 points Most recent by User_2025-02-03-19-30-01-975
-
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…
-
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
-
Possible to query an incident thread type (ie. private note) to contain a specific keyword (ie....Content I'm looking to create a report that displays only incidents that contain a specific word in a private note. I'm having no problem displaying incidents that both … -
Reporting on Incidents that were Saved with no Actual ChangesContent Reporting when an Agent opens an existing incident for viewing and then saves it without making any kind of changes. It appears when this happens, the user_trans… -
Wrong Language ReportedContent I wonder if anyone came across this situation? I have an incident (email) that has both the Incident Language and Contact Language set to Danish, but when I run …
-
to_number not working as expectedContent Code is below. I'm outputting all 3 fields individually. The first is 1, the second and third are both zero. When I add a new column with the definition below, I…
-
Documentation About Standart ReportsContent Hello, Where can I find documentartion about all Pre-Made Reports? I have a old version (051509v1_feedback_catalog_of_reports.pdf, 051509v1_marketing_catalog_of_… -
Export/Import From Test to ProdContent Hi All, We are in the middle of moving our configuration from our test environment to production environment for initial go-live. We exported and imported custom…User_2025-02-03-19-29-58-097 33 views 1 comment 2 points Most recent by User_2025-02-03-19-25-29-971
-
Inline editing for Account Hierarchy for multiple staff accountsContent Hello, I am looking for a good way to manage multiple staff account's account hierarchy. With the goal to be able to move accounts under new Managers faster than… -
Resetting Custom Filter in Schedule Back to Default?Content I attempted to do this by setting everything back to NO VALUE, but that doesn't seem to work. Is the ONLY OPTION deleting the schedule and starting over? Thanks,…
-
Error Saving reportsContent Anyone experiencing issues saving reports? Keep receiving this - AN ERROR HAS OCCURRED - ERROR RUNNING QUERY. Thing is, I'm not actually running the reports, jus…
-
Dashboard Drill-Down Level RefreshContent We have a dashboard that has a drill-down view. After clicking into the drill-down view the dashboard will eventually refresh (after 120 seconds) which causes th…