Jump to content

Search the Community

Showing results for tags 'measure'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Hornbill Platform and Applications
    • Announcements
    • Blog Article Discussions
    • General Non-Product Discussions
    • Application Beta Program
    • Collaboration
    • Service Manager
    • Project Manager
    • Customer Manager
    • Document Manager
    • Configuration Manager
    • Timesheet Manager
    • Live Chat
    • Board Manager
    • Mobile Apps
    • System Administration
    • Integration Connectors, API & Webhooks
    • Performance Analytics
    • Hornbill Switch On & Implementation Questions
  • About the Forum
    • Announcements
    • Suggestions and Feedback
    • Problems and Questions
  • Gamers Club's Games
  • Gamers Club's LFT

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Organisation


Location


Interests


AIM


MSN


Website URL


ICQ


Yahoo


Jabber


Skype

Found 11 results

  1. Whilst trying to diagnose some discrepancies between the number of rows returned via a measure and a report, I though I would try running a report on the saved columns held with the measure by using the 'Measure' source option in the report designer. However the output is not quite what I was expecting. The measure in question captures the data ranging column (example below is date_logged - h_datelogged) as the second column value, so entering the same period as the measure sample into the report, I get between 3 to 4 times as many rows returned with duplicate rows, but not necessarily identical. It appears the measure data structure is not quite I was expecting, which was one row for each request that was counted in the measure that meet the criteria. I have been trying to work out what logic or structure it is using but I am stumped. Anyone else tried reporting on measure entities and worked out what it is doing? Cheers Martyn
  2. At the moment you have a 'Title' field in the Measure which is both the actual name of the measure and also the display title of the said measure. When you have a large volume of measures like we do, we use a structured naming convention to organise them, however this means that when the measure is displayed it has the same name, which is not ideal. Therefore can the current field be duplicated, so there is a 'Measure Name' and 'Title', with the latter the display title that is used on display. Initial for existing measures, they would be set to the same value. Cheers Martyn
  3. At the moment you can only create measures on table objects and not entities (see link below to earlier post), therefore if you are wanting to use a custom field in your selection criteria you will need to do a sub query to include the appropriate request type specific tables which hold the custom fields for each type. The example below is for a measure we run to return the Response SLA performance based on the analyst who was the owner of the request when the request 'Response Timer' was completed, as this in our case will/may be different from the person who resolves it and completes the 'Resolution Timer'. We store the owner at the former stage in a custom field so therefore need to do the measure criteria against this and not the owner when it was resolved/closed. h_withinresponse in ('0','1') and ( (h_pk_reference in (SELECT h_fk_reference FROM h_itsm_incidents where h_custom_o='john.smith')) or (h_pk_reference in (SELECT h_fk_reference FROM h_itsm_servicerequests where h_custom_o='john.smith')) or (h_pk_reference in (SELECT h_fk_reference FROM h_itsm_changerequests where h_custom_o='john.smith')) ) At the moment we are not using the other request types, but the logic applied to prblems (h_itsm_problems), known errors (h_itsm_knownerrors) and releases (h_itms_releases). Note there are also some request specific fields in these linked tables as well as the custom fields, so if you need access to them as criteria the same would apply. Hopefully the above will help if you have a similar requirement. Cheers Martyn
  4. Afternoon all, I am trying to get a measure to run to show me the percentage of tickets a user has let breach response and also the same for resolve, However no matter what i do if i add the user in i cannot get the measure to come back with anything. I already have one running for IN and SR each month for the department, The below shows response outside SLA for the month So i figured that i just had to change the frequency to year and add a bit in the query to say AND h_resolvedby_username = 'username' But this just keeps bringing back 0 as the results. Any idea? Many thanks Hayley.
  5. When setting up a report on a measure, the drop down list of 'Report Measures' is not sorted and there is no filter. This make is quite cumbersome when you have a large number of measures. Can the drop down list be sorted alphabetically as a minimum and if possible a filter option added?. Cheers Martyn
  6. I sure this has been asked about before, but my search has not been able to find a post for it. I am trying to have a measure which captures the difference between the number of request opened in a week to the number of requests closed, i.e. whether we are keep ahead of the incoming or slipping behind. Cheers Martyn
  7. I am in the process of setting up a number of measures which do no have a Date Ranging criteria as I am attempt to capture the current 'state' of requests in an analyst's queue, i.e. number of open requests, new requests, on-hold etc. At the moment in order to start these running you have to set them to re-sample, but as there is no date ranging condition you will get x number of samples of the same value. When there is no date ranging criteria, can the system detect this and just sample the one current value? Cheers Martyn
  8. I am looking to implement a number of measures for each of my staff as part of performance monitoring. The measures are basically identical except the value in the selection criteria to control which analyst they relate too. It would be really helpful to be able to 'copy' a measure, rather than having to create each of them a fresh each time. Cheers Martyn
  9. Good afternoon, I have a measures question. We are trying to create a measure for first time fix's, in our Progressive capture for Incidents and Service Requests we have a custom form at the end that is called First time fix: I have named the Field ID first_time_fix - and it is a simple static drop down select box, with the options "yes" or "no" I want to be able to create a measure for it to fid out how many first time fixs we have for service requests and incidents. I don't know what to fill in under the table and key columns, this is what I have put but its not pulling anything up, obviously first_time_fix isn't going to work for this question so how can I put a measure in place for it? Many thanks Hayley.
  10. Afternoon all, Just a quick one I wanted to create a measure or widget that reports the top 3 catalog items logged against for service requests and for incidents. I cannot seam to figure out how to get this to report? Any ideas, Many Thanks
  11. Hi, what happens to the data in the database once the maximum sample is reached? Is the data deleted from the database?
×
×
  • Create New...