Scores
Except for NPS (Net Promotor Scores), scores can be shown in the report at any level. For information on Net Promotor scores, scroll to the bottom of this article.
| How to Show | Using the Merge Manager, select the Merge Type | Merge String |
| Percentage Score calculated by dividing the total score of the answers selected divided by the total potential score of the questions answered. | Percentage Score | {RatingScore.Score} |
| The average score of the answers selected. (as required for Likert-type reporting) | Average Points Score (Likert) | {RatingScore.ActualPoints} |
| The range of scores in a cohort. The difference between the average score of the top scoring response and the bottom scoring response. | Range - Average Score | {RatingScore.Range} |
| The range of percentage scores in a cohort. The difference between the percentage score of the top scoring response and the bottom scoring response. | Range - Percentage | {RatingScore.RangePC} |
| The minimum score in a cohort for the element or group specified. If, for example, a Section is specified it will be the minimum score for that section amongst the responses. If SubSection=All and QuestionNo=All as well, it will be the minimum score for all questions in that section. | Minimum Score | {RatingScore.Minimum} |
| The maximum score in a cohort for the element or group specified. If, for example, a Section is specified it will be the maximum score for that section amongst the responses. If SubSection=All and QuestionNo=All as well, it will be the maximum score for all questions in that section. | Maximum Score | {RatingScore.Maximum} |
| The minimum Percentage in a cohort for the element or group specified. If, for example, a Section is specified it will be the minimum percentage score for that section amongst the responses. If SubSection=All and QuestionNo=All as well, it will be the minimum percentage score for all questions in that section. | Minimum Percentage | {RatingScore.MinimumPC} |
| The maximum percentage score in a cohort for the element or group specified. If, for example, a Section is specified it will be the maximum percentage score for that section amongst the responses. If SubSection=All and QuestionNo=All as well, it will be the maximum percentage score for all questions in that section. | Maximum Percentage | {RatingScore.MaximumPC} |
The merge strings have these parameters available:
| How to show | Using the Merge Manager | Parameter | Notes |
| Total Result for this Assessment. | From "Show" choose Assessment | Survey | If the Section is also specified this parameter is ignored. |
| Results for all sections. | From "Show" choose Sections From "Section" choose All Sections | SectionNo=ALL | If the Subsections parameter is not used, there will be a result for each section. Logically this would only be used in conjunction with the top or bottom filter |
| Result for one section. | From "Show" choose Sections From "Section" choose Section to be displayed | SectionNo=n | If the Subsections parameter is not used, there will be one result. n=the section number |
| Results for all subsections within the specified sections | From "Show" choose Subsections From "Section" choose All Sections or Section name From "Subsection" choose All Sub Sections | SubSectionNo=ALL | The Section parameter must also be used. If the Questions parameter is not used, there will be a result for each subsection. Logically this would only be used in conjunction with the top or bottom filter |
| Result for one subsection. | From "Show" choose Subsections From "Section" choose Section name From "Subsection" choose Subsection to be displayed | SubSectionNo=n | The Section parameter must also be used. If the Questions parameter is not used, there will be one result. n=the subsection number |
| Results for all questions within the specified sections and subsections. | From "Show" choose Questions From "Section" choose Section name From "Subsection" choose All Subsections or Subsection name. From "Question" choose All Questions | QuestionNo=ALL | Section and Subsection parameters must also be used. Logically this would only be used in conjunction with the top or bottom filter |
| Result for one question. | From "Show" choose Questions From "Section" choose Section name. From "Subsection" choose Subsection name. From "Question" choose Question to be displayed | QuestionNo=n | Section and Subsection parameters must also be used. n=the question number |
| Results for all segmentations | From "Show" choose Segmentations From "Segmentation" choose All Segmentations | SegmentationNo=ALL | Can not be combined with other options (e.g. Sections or Subsections) Logically this would only be used in conjunction with the top or bottom filter |
| Result for one segmentation. | From "Show" choose Segmentations From "Segmentation" choose Segmentation to be displayed | SegmentationNo=n | Can not be combined with other options (e.g. Sections or Subsections) n = the Segmentation Number, this is available in the Segmentations function. |
Filters | |||
| How to | Using the Merge Manager | Parameter | Notes |
| Include all segmentation groups. | From "Segmentation Group" choose All Segmentation Groups | SegG=ALL | Only applicable if the SegmentationNo=ALL display option is taken |
| Include one segmentation group only. | From "Segmentation Group" choose Segmentation Group name | SegG=n | Only applicable if the Segmentation display option is taken |
| Select the nth Top scoring item in the specified element range | From "Options" choose Select Top. In "Top" enter a number - 1 for the top, 2 for the second top etc. Hit enter | Top=n | When using the Top function, the elements to display become the range for the Top to be selected from. For example, SectionNo=All Top=1 will show the top-scoring section. n=1 for the top-scoring item, n=2 for the 2nd top scoring item, etc. |
| Select the nth Bottom scoring item in the specified element range | From "Options" choose Select Bottom. In "Bottom" enter a number - 1 for the bottom, 2 for the second bottom etc. Hit enter | Bottom=n | When using the Bottom function, the elements to display become the range for the lowest scoring to be selected from. For example, SectionNo=All Bottom=1 will show the lowest scoring section. n=1 for the lowest scoring item, n=2 for the 2nd lowest scoring item, etc. |
| Filter the data to only use the specified Role | From "Options" choose Filter by Role. In "Role" enter the Role to use. | Identifier=nnnnnn | Filter the data to only use the specified Role. If the Role has spaces, replace them with an underscore. |
| Filter the data to only use the first Iteration | From "Options" choose Filter by Iteration. In "Iteration" Select "First Iteration". | Iteration=First | Filter the data to only use the First Iteration. |
| Filter the data to only use the last Iteration | From "Options" choose Filter by Iteration. In "Iteration" Select "Last Iteration". | Iteration=Last | Filter the data to only use the Last Iteration (i.e. the most recent). |
| Filter the data to only use the previous (2nd to last) Iteration | From "Options" choose Filter by Iteration. In "Iteration" Select "Previous Iteration". | Iteration=Previous | Filter the data to only use the Previous (2nd to last) Iteration. |
Options | |||
| How to | Using the Merge Manager | Parameter | Notes |
| Use calculations from an Advanced rating type. | From "Rating Type" choose the Rating Type to be used. | RatingType=n | n=Rating Type ID from Advanced rating screen. |
| Show decimals on the score (both the label, if one is shown and the size of the mark) | From "Options" choose Set the Decimals. In "Decimals" enter the number of decimal places. | Decimals=n | The number of decimal places for the Axis and the label (if any) |
Set the background color of the score based on the Rating. (NB the score must be in a table cell for this to work. The entire table cell will be colored.) Only applicable to Score and Actual Points. | From "Options" choose Background Color. In "Background Color" chose Rating. | BackgroundColour=Rating | The score must be in a table cell for this to work. The entire table cell will be colored. Rating Types can be used if separate color schemes are required. |
Choose the rating text based on the difference between two Segmentation Groups. Normally a Rating Type will be configured specifically for use with differences. | From "Options" select Differences From "Differences" select Difference Between Segmentations From "Options" select Base Segmentations | Metric=DiffSeg Base-SegG=n Base-SegmentationNo=ALL or Base-SegmentationNo=n | Display text selected based on the difference between two Segmentation Groups. If the Segmentation score is higher than the base Segmentation Score, the result will be positive, if it is below, the result will be negative. If SegmentationNo=ALL is specified, the Base and the display Segmentation groups must have matching segmentations in the same order. |
Choose the rating text based on the difference between two Iterations. Normally a Rating Type will be configured specifically for use with differences | From "Options" select Differences From "Differences" select Difference Between Iterations From "Options" select Base Iteration | Metric=DiffIteration Base-Iteration=(First, Previous, Last) | Display text selected based on the difference between two Iterations. If the Iteration score is higher than the base Iteration Score, the result will be positive, if it is below, the result will be negative. |
Choose the rating text based on the difference between two Roles. Normally a Rating Type will be configured specifically for use with differences. . | From "Options" select Differences From "Differences" select Difference Between Roles From "Options" select Base Role | Metric=DiffIdentifier Base-Identifier=nnnnnnn | Display text selected based on the difference for between two Roles. If the actual Role score is higher than the base Role Score, the result will be positive, if it is below, the result will be negative. |
Choose the rating text based on the difference between two Segmentation Groups. Normally a Rating Type will be configured specifically for use with differences | From "Options" select Differences From "Differences" select Difference to Benchmark From "Options" select Benchmark | Metric=DiffBM BM1=n (0 or Classifier No) | Display text selected based on the difference between the score and the Benchmark. If the actual score is higher than the Benchmark Score, the result will be positive, if it is below, the result will be negative. |
NPS Score
The NPS (Net Promotor Scores), can only be calculated and reported for a question. The question must have must be scored 1 to 10, the system will calculate the NPS as:
The proportion of respondents in the cohort that scored 9 or 10 (Promoters) - the proportion of respondents that scored 6 or less (Detractors). The result is presented as a number between 100 and -100
| How to Show | Using the Merge Manager, select the Merge Type | Merge String |
| Net Promoter Score. | NPS Score | {NPS.Score} |
The only parameter available:
| How to show | Using the Merge Manager | Parameter | Notes |
| Specify the Question to be scored. | From "Show" choose Specified Question. From "Specified Question" select the Question. | Sn SSn Qnn | The Section Number, Subsection number, and Question Number. |
Comments
0 comments
Please sign in to leave a comment.