Stephen Hutchinson Posted December 30, 2016 Share Posted December 30, 2016 I am trying to create reports ie How many tickets logged per year. Can anyone assist please ? Link to comment Share on other sites More sharing options...
Hornbill Staff DR Posted December 30, 2016 Share Posted December 30, 2016 Hi Stephen,  thanks for your post. A metric such as this is possible with both Hornbill Advanced Analytics and the Reports functionality located in Hornbill Administration.Advanced Analytics -  Home > Service Manager > Advanced Analytics - If you want a simple count, a measure can be created to obtain the number of requests logged during a specified sample period. Upon creating a measure, specify the frequency as "Yearly", the Value Aggregate as "Count, and the Date Ranging Column as "Date Logged". In the query where clause add any specific criteria that you need e.g. if you want to limit the count to only incidents, specify "requesttype = 'incident' ". Save the measure and then select re-sample. When a measure is set to sample on a yearly basis, the count will be gathered at 23:59 on the 31st December each year and will continue to do so until the measure is suspended or deleted.Reports - Home > Service Manager > Reports - It is possible to build a Report to output a list of the requests logged within a specified date range. This is done in the "filter" tab by specifying a filter which allows you to enter a date range at the point of running the report. The image shows the filter configuration that will allow you to do this. It will also be necessary to add any other filter criteria that you desire e.g. request type. With this filter configured, when you run the report (by clicking the "Play" button towards the top right) you will be presented with a pop-up where you can choose your date range. Hope that helps. Dan Link to comment Share on other sites More sharing options...
Stephen Hutchinson Posted December 30, 2016 Author Share Posted December 30, 2016 Thanks Daniel :-) Link to comment Share on other sites More sharing options...
Stephen Hutchinson Posted January 4, 2017 Author Share Posted January 4, 2017 I can not find out how to find the filter op Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now