Rating tables are replaced by the Tables merge string and are only documented here for Legacy purposes.
Rating tables show comparative scores between the roles. For example:
The merge string for this table was {RatingTable[SplitType=I SectionNo=ALL Direction=Horizontal OrderType=Alpha Order=Asc]}. Note that the OrderType and Order parameters have caused the Section names and roles to be in alphabetical order.
You can, at the Question level, list questions showing the actual scores (for Likert type reporting), with or without decimal places, and with or without an Average showing for the rows and columns.
The merge string for the above is {RatingTable[SplitType=I SectionNo=2 SubSectionNo=ALL QuestionNo=ALL Direction=Horizontal ShowActual=Y Totals=Y Decimals=1]}
Elements to Display | |||
| 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. |
| 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. |
| 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. |
| 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) May be filtered by segmentation groups or Top/Bottom. |
| 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 |
Options | |||
| How to | Using the Merge Manager | Parameter | Notes |
| Show scores as a percentage | From "Display" select Percentage | (none) | Percentage scores will be displayed by default. |
| Show scores as an average value (Likert Style) | From "Display" select Average Score (Likert Style) | ShowActual=Y | Show the average of the points scored for all questions included in the selection. |
| Use ratings from an Advanced rating type. | From "Rating Type" choose the Rating Type to be used. | RatingType=n | n=Rating Type ID from Advanced ratings 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) |
| Order Elements by Score ascending (lowest at the top) | From "Options" choose Sort Type. From "Sort Type" select Score. From "Options" choose Sort Order. From "Sort Order" select Ascending. | OrderType=Score Order=Asc | Score order of the mark labels |
| Order Elements by Score descending (highest to lowest) | From "Options" choose Sort Type. From "Sort Type" select Score. From "Options" choose Sort Order. From "Sort Order" select Descending. | OrderType=Score Order=Desc | Alphabetical order of the mark labels |
| Order Elements by Name alphabetically ascending (A - Z) | From "Options" choose Sort Type. From "Sort Type" select Alphabetical. From "Options" choose Sort Order. From "Sort Order" select Ascending. | OrderType=Alpha Order=Asc | Alphabetical order of the mark labels |
| Order Elements by Name alphabetically descending (Z - A) | From "Options" choose Sort Type. From "Sort Type" select Alphabetical. From "Options" choose Sort Order. From "Sort Order" select Descending. | OrderType=Alpha Order=Desc | Alphabetical order of the mark labels |
| Display multiple charts down the page. | From "Options" choose Set the Direction. From "Set the Direction" select Vertical. | Direction=Vertical | Displays multiple charts down the page. |
| Display multiple charts across the page. | From "Options" choose Set the Direction. From "Set the Direction" select Horizontal. | Direction=Horizontal | Displays multiple charts across the page. |
| Display Totals as an average. | From "Options" choose Display Totals. From "Display Totals" select Display Totals. | Totals=Y | Display Totals as an average. |
Cohort Groupings | |||
| How to | Using the Merge Manager | Parameter | Notes |
| Group all the responses into one result | From "Options" choose Set the Cohort Splits. From "Cohort Splits" select Average all Responses. | SplitType=N | No Split |
| Group responses by Role | From "Options" choose Set the Cohort Splits. From "Cohort Splits" select Group by Role. | SplitType=I | Show the average of responses, grouped by Role or the Role |
| Group responses by Month and Year | From "Options" choose Set the Cohort Splits. From "Cohort Splits" select Group by Month/Year. | SplitType=M | Show the average of responses, grouped by Month and Year |
| Group responses by Year | From "Options" choose Set the Cohort Splits. From "Cohort Splits" select Group by Year. | SplitType=Y | Show the average of responses, grouped by Year |
| 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 Role. If the Role has spaces, replace them with an underscore. |
Examples of Rating table merge strings:
|
{RatingTable[SectionNo=All]} |
Lists each Role and each section with their rating score vertically |
|
{RatingTable[ShowActual=Y]} |
Lists each Role their actual score. |
Multiple parameters can be specified in one merge string with one space between each one. For example:{RatingTable[SplitType=I SectionNo=2 SubSectionNo=1 QuestionNo=ALL Direction=Horizontal]}
Comments
0 comments
Please sign in to leave a comment.