Jump to content

Joyce

Hornbill Users
  • Content count

    40
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Joyce

  • Rank
    Advanced Member
  1. Field for ticket 'Assigned to'

    Hi I want to create a report for tickets which have been re-assigned more than one. Which table and which field have ticket assignment details? Thanks. Regards, Joyce
  2. Hi @Bob Dickinson I want to create a report for tickets which have been re-assigned more than one. Which table and which field have ticket assignment details? Thanks. Regards, Joyce
  3. Thanks @Bob Dickinson, I will try that, but this should only consider ''Resolved' and 'closed' Incidents (Where statement: h_requesttype='Incident' AND (h_status = "status.resolved" OR h_status = "status.closed") AND h_withinfix='1' AND h_dateresolved >= '2017-08-01 00:00:00' ) so technically there shouldn't be a null value? Regards, Joyce
  4. Hi @Bob Dickinson As a work around to this we have create 'list of counter' widget, as 'AVG', 'h_withinfix' from 'h_itsm_requests' Where :h_requesttype='Incident' AND h_fk_servicename like '%t1%' AND (h_status = "status.resolved" OR h_status = "status.closed") AND h_dateresolved >= '2017-08-01 00:00:00' AND h_resolvedby_teamname ='Operations''. The value from above, which should be average for Tier Incidents resolved from 01/08/2017 to date is completely different from taking a count of all T1 incidents resolved from 01/08/2017 withinfix divided by total T1 incidents resolved from 01/08/2017 to date. Please refer to two widget : SLAM - SLA performance MTD- Month to Date - Operations Support SLAM - SLA Volume performance MTD- Month to Date - Operations Team Can you advise, why these values are very different? Regards Joyce
  5. Function for yesterday's date

    They provide different answers
  6. Function for yesterday's date

    HI Bob, What if the the SQL Widget is 'AVG', will the select be h_withinfix or still h_pk_reference? Regards, Joyce
  7. Function for yesterday's date

    Hi @Bob Dickinson I am getting similar problem with a month count compare to measure. This is a count from counter widget gives me a 714: While the 'Monthly Measure' for the same count gives me 728 Am I doing the dates wrong? Thanks. Regards, Joyce
  8. Function for yesterday's date

    Hi Bob, We have decided not to use the yesterday function at the moment. But I will keep it in mind, for next time. Thanks. Regards, Joyce
  9. Function for yesterday's date

    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
  10. 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
  11. Change Request Calendar

    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
  12. 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
  13. Great thanks @Bob Dickinson
  14. 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
  15. 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
×