Difference between revisions of "Measures"
Jump to navigation
Jump to search
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| + | This document can now be found at its new location in the [https://docs.hornbill.com/esp-config/advanced-analytics/measures/ Hornbill Document Library]. | ||
| + | |||
| + | [[file:hornbill-document-library.png|Measures|link=https://docs.hornbill.com/esp-config/advanced-analytics/measures/]] | ||
| + | |||
| + | <!-- | ||
<div style="border:1px solid #90C0FF; background:#D0E0FF; width:99%; padding:4px; margin-bottom:10px;"> | <div style="border:1px solid #90C0FF; background:#D0E0FF; width:99%; padding:4px; margin-bottom:10px;"> | ||
__NOTOC__ | __NOTOC__ | ||
| Line 10: | Line 15: | ||
|style="width:73%"| | |style="width:73%"| | ||
== Introduction == | == Introduction == | ||
| − | In order to provide strategic business intelligence through reporting one of the key requirements is to define measures that are sampled and stored periodically. Once these measures are stored over a period of time the type of reporting possible is expanded considerably | + | In order to provide strategic business intelligence through reporting, one of the key requirements is to define measures that are sampled and stored periodically. Once these measures are stored over a period of time, the type of reporting possible is expanded considerably. It includes trending, performance measurement against goals and thresholds, and predictions based on historical trends. |
<br> | <br> | ||
| Line 22: | Line 27: | ||
:* [[Reports]] | :* [[Reports]] | ||
|} | |} | ||
| − | The creation of a Measure includes selecting the data | + | The creation of a Measure includes selecting the data you wish to sample, the frequency that the samples are taken, and the targets and goals you wish to achieve. |
<br> | <br> | ||
The information provided by measures can be used to build Widgets for displaying on Dashboards. The output consists of numerical values that enable the population of: | The information provided by measures can be used to build Widgets for displaying on Dashboards. The output consists of numerical values that enable the population of: | ||
| Line 38: | Line 43: | ||
[[File:newMeasure.png |thumb|right|link=https://wiki.hornbill.com/images/1/16/NewMeasure.png|Creating a new measure]] | [[File:newMeasure.png |thumb|right|link=https://wiki.hornbill.com/images/1/16/NewMeasure.png|Creating a new measure]] | ||
:* '''Title''' | :* '''Title''' | ||
| − | :: The title is visible from | + | :: The title is visible from within the list of defined measures. It is also used when creating a widget based on a measure. |
:* '''Description''' | :* '''Description''' | ||
:: A details description of the measure can be provided so that other users with the ability to view and edit this measure can understand more about the measure. | :: A details description of the measure can be provided so that other users with the ability to view and edit this measure can understand more about the measure. | ||
| Line 67: | Line 72: | ||
:::: A numeric value that represents the sum of a series of values in the data set | :::: A numeric value that represents the sum of a series of values in the data set | ||
:::* '''''PERCENT''''' | :::* '''''PERCENT''''' | ||
| − | :::: A percentage of items in a given data set that match | + | :::: A percentage of items in a given data set that match criterion from a larger subset. For example, the count of records where column X = 5 in a set of records in a given date range, is returned as a percentage. |
:* '''Scorecard Limit''' | :* '''Scorecard Limit''' | ||
| − | :: This is the number of samples | + | :: This is the number of samples shown against a scorecard. [[File:scorecard.png |150px|Scorecard]] |
:* '''Sparkline Limit''' | :* '''Sparkline Limit''' | ||
| − | :: This is the number of samples | + | :: This is the number of samples shown against a sparkline. [[File:sparkline.png |150px|Sparkline]] |
:* '''Maximum Sample History''' | :* '''Maximum Sample History''' | ||
| − | :: This is the maximum number of samples that the system will store against this | + | :: This is the maximum number of samples that the system will store against this measure. |
<br> | <br> | ||
<br> | <br> | ||
| Line 86: | Line 91: | ||
:: This is the count that needs to be achieved in order for the measure to breach its target. | :: This is the count that needs to be achieved in order for the measure to breach its target. | ||
<br> | <br> | ||
| − | {{infobox|The direction of the threshold can be changed by clicking the arrow to the right of the threshold targets. In terms of requests or requests logged you would want to say that the lower the number is, the better the teams are performing, | + | {{infobox|The direction of the threshold can be changed by clicking the arrow to the right of the threshold targets. In terms of requests or requests logged, you would want to say that the lower the number is, the better the teams are performing; however, for the total number of resolved calls, a higher count is better.}} |
<br> | <br> | ||
<br> | <br> | ||
| Line 99: | Line 104: | ||
:: This is where you would specify any additional tables from which the measure will collect its data. | :: This is where you would specify any additional tables from which the measure will collect its data. | ||
:* '''Date Ranging Column''' | :* '''Date Ranging Column''' | ||
| − | :: Here you select a date column that the measure will base its data collection on. The dates held in this column will be used to count/sum/average the records based on frequency such as last month, last year or all records since the beginning of this year. | + | :: Here, you select a date column that the measure will base its data collection on. The dates held in this column will be used to count/sum/average the records based on frequency, such as last month, last year or all records since the beginning of this year. |
:* '''Date Ranging Column 2''' | :* '''Date Ranging Column 2''' | ||
| − | :: This is an optional field where you can provide a second date column to be included as part of the criteria for data collection. This will be used to count/sum/average the records where the collected data for the selected frequency will be based on both ''Date Ranging Column'' AND ''Date Ranging Column 2'' | + | :: This is an optional field where you can provide a second date column to be included as part of the criteria for data collection. This will be used to count/sum/average the records where the collected data for the selected frequency will be based on both ''Date Ranging Column'' AND ''Date Ranging Column 2.'' |
:* '''Query where clause''' | :* '''Query where clause''' | ||
:: This is where you can add a filter to the measure. | :: This is where you can add a filter to the measure. | ||
| Line 107: | Line 112: | ||
:: This is where you can add a percentage filter to the measure. | :: This is where you can add a percentage filter to the measure. | ||
:* '''Saved Data Columns''' | :* '''Saved Data Columns''' | ||
| − | :: This is where you can specify which | + | :: This is where you can specify which columns are available to be drilled down on and grouped by. '''Unless columns are defined against the measure, they will not be available to group by or drill down when configuring widget content based on the measure'''. |
<br> | <br> | ||
<br> | <br> | ||
| Line 113: | Line 118: | ||
==Examples== | ==Examples== | ||
| − | In this section we will include examples of the different types of Measure which can be defined | + | In this section, we will include examples of the different types of Measure which can be defined. |
:* Count - Incidents Logged Per Month {{#ev:youtube|-rnzzGBzc6g|400|left}} | :* Count - Incidents Logged Per Month {{#ev:youtube|-rnzzGBzc6g|400|left}} | ||
| − | + | --> | |
| − | [[Category: | + | [[Category:HDOC]] |
Latest revision as of 20:07, 11 April 2024
This document can now be found at its new location in the Hornbill Document Library.
