Statistics Table Reporting
In this guide we will cover: – What is a Statistics Table? – Creating a Statistics Table – Reporting on Statistics Tables Related Guides: Ticket Volumes and Forecasting Note: The features outlined in this guide are available as of v2.208.1+. What is a Statistics Table? Statistics tables are type of Custom Table which allow you […]
How to Use Custom CSS and HTML on Halo Reports
In this guide we will cover: – How to customise the appearance of Report tables using HTML – Pin Scrollbar to the bottom of the page v2.208+ HTML can be applied to reports in Halo to customise how they appear/are formatted. This allows you to completely customise how your reports look. How to customise the appearance […]
Ticket Volumes and Forecasting
In this guide we will cover: – What is Ticket Forecasting? – Ticket Volume History – Configuring Forecasting – Running Forecasts – Reporting on Forecast Output – Adding Forecasts to Existing Reports (v2.202.1+) Related Guides: Nixtla TimeGPT Integration Note: Forecasting via Nixtla TimeGPT is available from v2.188.1+, but built-in functionality is available as of v2.208.1. […]
Common SQL Tables and Joins
In this guide we will cover: – Common SQL Tables and What Each Contains – Example Joins Between Them This guide will cover some commonly referenced SQL tables and the information that can be pulled from each. A majority of the tables listed here are also within the following schemas. ITSM Schema PSA Schema CRM […]
Optimising Reports to Improve Efficiency
In this guide we will cover: – Selective Data Retrieval – Join Recommendations – Subquery Alternatives – Minimising Use of Wildcard Characters Larger or more complex reports can potentially have slower loading times. This guide outlines a few key points to consider when writing reports to help combat this. Selective Data Retrieval Using a SELECT […]
Automatic HTML Additions to Reporting
In this guide we will cover: – Example of Automatic Additions – List of Column Names Automatic HTML additions can be added to reports to apply hyperlinks within certain columns. Example of Automatic Additions Halo supports the addition of hyperlinks on rows without the need for writing custom HTML for the report. The links are […]
Use AI to analyse Report Data
In this guide we will cover: – Enabling AI Report Analysis – Analysing a Report – Reporting on Summaries AI programs can be used to analyse data contained within reports, and provide a summary that shows at the top of the report. This summary can be reported on as well. Enabling AI Report Analysis (v2.179.1+) […]
Database Reporting Functions
In this guide we will cover: – What is a Database Function? – List of Database Functions – Example Report What is a Database Function? A database function is a section of text that runs a built-in SQL query when used in another query. This can be used to format a report without making your […]
Report Online Repository
In this guide we will cover: – What is the Online Repository? – Downloading Reports – Downloading Data Sources Related Guides: Report Builder Report Data Sources Reports and Scheduling What is the Online Repository? The Online Repository is Halo's built-in compilation of pre-made reports and data sources that are available for download and use within […]
(HH:MM) Conversion of a field in SQL to Hours and Minutes
Converting a decimal hours field to an Hours and Minutes field ,left(CAST(CONVERT(VARCHAR,DATEADD(SECOND, {INSERT YOUR DECIMAL HOURS FIELD HERE} * 3600, 0),108) AS TIME), 5) as [Insert Field Name]