Joyce

Thanks Bob. I have try the above, but when compare a count from 'Daily measure' and the count from above, I am not getting the same value. Do i need to specify times? Thanks. Regards, Joyce Tha

Hi What function can be used in reporting to get yesterday's date in Horn bill? I have tried: h_datelogged >= CURRENT_DATE- 1 ,and it doesn't give me correct value Thanks. Regards, Joyce

Hi, I need to put 'Routine Maintenance' dates on our change management Calendar. The calendar schedules changes automatic, but I want to pre-schedule our routine maintenance date for the next six month, hence we can see how many changes are happening outside the schedule maintenance window. Is there a way to edit the calendar? Thanks. Regards, Joyce

Hi, I am trying to create a report, which provide counts on customer division (which is in one of the custom field). This division comes in different ways (from our AD), but one division, might have more than one 'Customer Division'. For example, PLC Division might cover (health& safety, HR, etc). So I want a column, in h_itsm_request which says If (left(custom_field,13)='Health&safety','PLC',(if(left(custom_field,2)='HR','PLC',)) Then I can use this column, to count the number for 'PLC' At the moment, i get separate counts, ie: Health&Safety = 5 and then HR = 10. So i have to manually add them up . Or please advise alternative way to do this, in a bar chart widget Thanks. Regards, Joyce

Great thanks @Bob Dickinson

Hi @Bob Dickinson I have create a report with the chart I am after, The report name is: Test Mobile Phone Request Report Please let me know, if I can create similar chart as a widget. Thanks. Regards, Joyce

Hi, Can I create a data chart widget, from joining two tables? If I choose data type 'sql group by' only get option for one table . Is there a way to select/join two tables (manage to join in reports, as well as on list of data widget, but not for data chart widget') Thanks. Regards, Joyce

Need to do it as, a widget, as part of a daily dashboard.

Thanks @Ehsan. The value i have on 'Assign to' from running select query on database direct is something like urn:sys:group:Instance/company/department/team/. I am interested on filtering by Team. So if I say: h_sys_tasks.h_assigned_to like '%department%' I am not getting any data returned, but sql error. Thanks. Regards, Joyce

This has worked for me. Thank you.

Hi, which field on h_sys_tasks table are the columns seen on 'Activities view' linked with? I am after columns 'Assigned to', and 'Status' . I am trying to create a widget for count of open/active task by team (assigned to a team). Thanks. Regards, JOyce

Thanks. I will try the Plugin suggested above

Thanks I will try

Hi, I am trying to create a 'live counter ' for ticket logged today, as list of counter widget. How do I felt for it to count tickets logged today? so what should h_Datelogged be equals to? in the sql query. I have try, now() and Today() but I am not getting any value. Thanks. Regards, Joyce

yes, my format was change, I am missing a whole widget in the middle (please see second pdf file uploaded below). So this will not work for us. Regards, Joyce Hornbill sample report.docx Administration _ Outstanding Ticket Volumes.pdf

Hi, Is it possible to have a feature to be able to export dashboard into PDF file? We are required to provide monthly report to our directors, who do not have dashboard viewing access on Hornbill. So we need to be able to send them a copy of the dashboard. Thanks Regards, Joyce

ok, Thanks @Victor

Hi, How can I add custom field defined on progressive capture form, to display in the view? In our change Request form/ progressive capture, we have ' change category and change Priority' (which are different from the system request priority and category), defined by custom field. I want to create change management view which shows these fields. How can I make them available, to be used in views? Thanks. Regards Joyce

Hi Bob, Thank you for the above. I have tested it in our environment. The count is correct, but the percentage is slightly different (correct value was 57. 89474 while value displayed on the widget is 59.4595. This could be due to our data. Thanks Regards, Joyce

OK Thanks @Victor. We will use notification alerts

How can i send, 'email Notification' to more than one person, in the automated task node? In our change request BPM, we need to send email to multiple people to approve change, then send email to request owner and request creator when change request has been approved. Thanks. Regards, Joyce

Hi, Currently for daily run measures/widget, based on a date (eg DateResolved), gives count on that day. I am looking for a way to get total count/ percentage within a current month (from start of month to date), of ticket resolved within SLA, but the widget should update/run daily. So say, '80% of Tier 1 tickets, resolved from 1st May to date, have been resolved within SLA, ' Current i have the daily measure, with daily counts like this (see attached file) Percentege resolved in a moth within fix.docx Thanks. Regards, Joyce

Fantastic @Victor, this is exactly what i need. Thanks

Yes I was thinking the same, using multi series with Sql .

Looking for something like this Request by age-Hornbill.docx