Reporting

Adding a page break (page-break) in the HTML for PDF documents (IronPDF)

Adding Dashboards to Custom Tabs

This article provides a guide on adding dashboards to custom tabs, giving users the ability to display dashboards specific to certain entities like tickets, customers, and users. The guide explains how to create these custom tabs, configure dashboards, and filter dashboard data to show only relevant information for the selected entity, such as a specific customer or user. It also covers importing and exporting dashboards using JSON, as well as troubleshooting common issues with filters on dashboards.

AI Report Builder

Automatic HTML Additions to Reporting

The article discusses adding automatic HTML hyperlinks to reports, enabling easy navigation via clickable links in certain columns like Tickets and Assets. It lists column names that support hyperlinking, such as 'ticketid' and 'assetid', and explains how to apply these hyperlinks without custom HTML. The guide also offers instructions for renaming ticket or asset entities in column entries to maintain functionality, allowing flexibility in report customization.

Charts and Graphs in Reports

This article provides a comprehensive guide on incorporating charts and graphs into reports for better data visualization. It covers the process of adding charts, customizing their appearance, and features like trendlines and labels. Various chart types such as bar, line, pie, and funnel charts are discussed, including their use cases. The guide explains how to set up schedules for including these charts in reports and how to use different visualization tools to present business data effectively. Emphasis is placed on customizing charts to suit specific reporting needs.

Configuring Custom Appearances in Reports (using HTML)

This article provides guidance on customizing the appearance of reports using HTML. It covers configuring report table headers, rows, grouping, and totals with HTML to enhance the display. It includes examples of inserting HTML blocks to modify appearance, such as adding hyperlinks to agent names via dynamic URLs, centering text, and changing text color in reports. The article also explains using SQL queries to expose necessary data for HTML customization and offers snippets for various HTML customizations.

Consignment PDFs

Creating a Report From an Action

Dashboard Publishing Guide

Halo In-App Dashboard

This article provides a comprehensive guide on creating and managing in-app dashboards in Halo. It covers topics such as adding and customizing widgets, setting dashboards on the home screen, filtering data, and using custom CSS for styling. The guide also explains various widget types like Ticket List, Report Data, and Report Chart, and details how to configure charts within dashboards. Additionally, it discusses syncing changes between instances and tracking changes to dashboards for version v2.212.1+. The article is designed to help admins and agents effectively visualize and manage data through accessible dashboards.

How to Restrict Users Access to Reports

This article explains how to control user access to reports within a portal. It details steps to make reports available in the portal, restrict access to specific reports, and make reports publicly accessible. Access can be limited by configuring visibility restrictions on portal buttons or setting user access permissions at different organizational levels. The article also describes how to publish reports via dashboards for public viewing and how to share raw report data while managing anonymous access settings to prevent unauthorized report sharing.

Optimising Reports to Improve Efficiency

This guide provides methods to enhance report efficiency by optimizing SQL queries. Key recommendations include avoiding SELECT * statements to fetch only necessary data, using indexed columns for filters, and preferring JOINs over LEFT/RIGHT joins and subqueries for better performance. It advises minimizing the use of wildcard characters as they demand more processing time, suggesting the use of specific filters like user IDs instead. Examples illustrate how these practices can lead to faster report generation and improved query performance.

Report Builder

This guide explains how to use the Query Builder function in the reporting suite to create custom reports without SQL knowledge. The article covers steps such as opening the Query Builder, adding fields and conditions, generating the report, applying filters, and saving it. It also provides customization options like sorting, grouping, and using count fields. Additionally, it describes how to create SQL queries using the Query Builder for users with SQL knowledge and provides guidance on report usage and customization.

Report filters in the URI parameters for report links

Reporting Access Control

This article provides guidance on managing access control for reports, introducing three methods for restricting report access in version 2.208.1 and later. Access control can be applied to report groups, data sources, and composite reports, with permissions determining editing capabilities. To set properly, saved reports must be edited to adjust access levels. Agents may have permissions to create reports or data sources, with access options tailored at the group, report, or source level. Detailed steps for applying access controls are included for report groups, composite reports, and data sources.

Reports and Scheduling

The article provides detailed guidance on how to effectively use the reporting and scheduling features within a service desk environment. It explains how to generate and customize ticket reports, utilize the side pane dashboard, and create reports using various tools such as SQL Query Builder. Users can schedule reports to be sent automatically to specified parties and configure reports to display viewer-specific information. The guide also offers tips on customizing report formats, managing report changes, and accessing an extensive online repository for pre-made reports.

Restricting Agent Reporting Access

The article provides a comprehensive guide on restricting agent access to reporting modules. It covers setting restrictions based on agent roles and individual profiles, controlling access to specific reports, and managing report groups. It also details how to restrict the types of reports agents can create by limiting data source access, and explains how to ensure agents only access data aligned with their permissions. Additional guidance is given on managing sensitive data and ensuring agents adhere to data visibility rules based on their roles and permissions.

Service Desk Incident Reports - Available Out of the Box

Statistics Tables

The article provides a guide on creating and using Statistics Tables, which are custom tables for capturing point-in-time data through regular SQL queries. It explains how to set up these tables, write SQL queries, configure table schemas, and schedule data captures for intervals like daily, weekly, or monthly. The guide also details how to generate and test the initial data set, and how to use the data in reporting scenarios. Statistics Tables simplify complex reports and prepare datasets for forecasting.

The Report Screen Explained

Ticket Volumes and Forecasting

This article provides a comprehensive guide on ticket forecasting, using historical ticket volume data to predict future inbound volumes. It covers configuring and running forecasts, utilizing the Nixtla TimeGPT integration for more accuracy, and reporting on forecast outputs. The guide includes steps for configuring ticket volume tracking, setting up forecasts, choosing forecasting models, and adding forecasts to reports. The article outlines using moving average, linear regression, and other methods while offering tools for visualizing data in charts and tables. New features enable configuring reports to display predicted values, enhancing reporting capabilities.