Multi Horizontal Bar Charts are used:
- In feedback reports to show benchmark results alongside response results.
- In cohort reports to show comparative results withing the cohort, optionally alongside benchmark results.
| Using Percentages | Using Likert Scoring |
| Inverting Values | Using Rating Bands |
| Using Rating Lines | Using Background Colors or Shading |
| Showing Benchmark Results | Answer Counts split by Ratings |
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. |
| Show Count of responses in the selection within a cohort | From "Display" select Count | Metric=Count | Show the number of respondents that selected each answer in the cohort. |
| Show percentage of each selection in a cohort | From "Display" select CountPC | Metric=CountPC | Show the percentage of respondents in the selection within a cohort |
| Show the difference between two Segmentation Groups as an Actual (Likert) score or percentage. | From "Display" select Difference Between Segmentations or Difference Between Segmentations %
From "Options" select Base Segmentations | Metric=DiffSeg or Metric=DiffSegPC Base-SegG=n Base-SegmentationNo=ALL or Base-SegmentationNo=n | Calculate the difference for the actual score or percentage 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. |
| Show the difference between two Iterations Groups as an Actual (Likert) score or percentage. | From "Display" select Difference Between Iterations or Difference Between Iterations % From "Options" select Base Iteration | Metric=DiffIteration or Metric=DiffIterationPC Base-Iteration=(First, Previous, Last) | Calculate the difference for the actual score ir percentage 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. |
| Show the difference between two Roles as an Actual (Likert) score or percentage. | From "Display" select Difference Between Roles or Difference Between Roles % From "Options" select Base Role | Metric=DiffIdentifier or Metric=DiffIdentifierPC Base-Identifier=nnnnnnn | Calculate the difference for the actual score or percentage 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. |
| Show the difference between the score and the Benchmark as an Actual (Likert) score or percentage | From "Display" select Difference to Benchmark or Difference to Benchmark % From "Options" select Benchmark | Metric=DiffBM or Metric=DiffBMPC BM1=n (0 or Classifier No) | Calculate the difference between the score or percentage 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. |
| Show the range of response scores in the selection within a cohort | From "Display" select Range | Metric=Range | Show the range in scores in the selection within a cohort. |
| Show the percentage range of response scores in the selection within a cohort | From "Display" select RangePC | Metric=RangePC | Show the percentage range of response scores in the selection within a cohort |
| 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 the score on each mark (percentage or actual score). | From "Options" choose Display Labels. From "Display Labels" select Labels. | Label=Y | Labels show the mark value in the Display Format (percentages or actual scores). |
| 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 height of the graphic (overriding the default) | From "Options" choose Height. In "Height" enter the height required in pixels. | Height=nnn | The height of the graphic. If the Width is not specified the system will calculate the width proportionately. The default height is 300 pixels. |
| Set the Width of the graphic (overriding the default) | From "Options" choose Width. In "Width" enter the width required in pixels. | Width=nnn | The Width of the graphic. If the Height is not specified the system will use the default height. The default width is 600 pixels. |
| Select the Font for the Legends and Labels | From "Options" choose Font. From "Font" select the required font. | Font=[name] | The fonts available are listed in the Merge Manager. If they have a space in the name it is replaced by an underscore. |
| Select the Font Size for the Legends and Labels | From "Options" choose Font Size. In "Font Size" enter the required font size in points. | FontSize=n | n = the font size in points. |
| Select the Bar Thickness overriding the system default (which is based on the available space) | From "Options" choose Bar Thickness. In "Bar Thickness" enter the required font size in points. | BarSize=n | n = the thickness of the par in pixels. Between 20-40 is typical. 30 is average. This will override the Height parameter. The system will calculate the space required for the bars, plus an allowance for the Axis and Legend (if any) |
| Select the Background color for the chart, or make it transparent | From "Options" choose Background. In "Background" enter the Color code (#nnnnnn) or "null" if a transparent background is required | Background=#CCCCCCC | #CCCCCCC = the Color code (#nnnnnn) or "null" if a transparent background is required. eg #FFFFFF = white. |
| Display Rating Bands as a background | From "Options" choose Rating Bands. From "Rating Bands" select Display Rating Bands. | RatingBands=Y | Displays background color bands, based on the rating. The Rating Type can be specified if a Rating other than the base Rating is required. |
| Display Rating Lines as a background | From "Options" choose Rating Lines. In "Rating Lines" enter the line width required in pixels. | RatingLine=n | Displays color lines, based on the rating. The Rating Type can be specified if a Rating other than the base Rating is required. |
| Set the Label Color | From "Options" choose Label color. In "Specify Label Color" enter the color code in the format #nnnnnn. | LabelColor=#CCCCCCC | #CCCCCCC = the Color code (#nnnnnn) for the Label (score). |
| Set the Axis Colors for the chart | From "Options" choose "Axis Color" In "Axis Color" enter the Hex code for the colors, separated by a comma. | AxisColor=#FFFFFF | |
| Don't show the Title | From "Options" choose Title Rules. From "Title Rules" select None. | Title=N | No Title is shown (this is the section / subsection / question / answer name shown alonside each set of bars) |
| Don't show the Y-Axis | From "Options" choose Y Axis Rules. From "Y Axis Rules" select None. | YAxis=N | The Y Axis is not shown (this is the percentages or numbers for Likert Scores) |
| Set the maximum value of the Score Axis. | From "Options" choose Set the Y Axis Maximum. In "Set the Y Axis Maximum" enter the maximum value. | YAxisMax=n | The Y (Vertical) axis maximum value. |
| Set the increment of the Score Axis. | From "Options" choose Set the Y Axis Increment. In "Set the Y Axis Increment" enter the increment value (e.g. 1). | YAxisInc=n | The Y (Vertical) axis increment of the tick marks. |
| Display a benchmark made up of all previous responses where the response Classifier = the benchmark Classifier | From "Options" choose Benchmark 1. From "Benchmark 1" select the required group, either All Responses or filtered by Classifier. | BM1=n | n = 0 for All Responses. Otherwise n= the Classifier No (from the Classifier table) |
| Display a second benchmark made up of all previous responses where the response Classifier = the benchmark Classifier | From "Options" choose Benchmark 2. From "Benchmark 2" select the required group, either All Responses or filtered by Classifier. | BM2=n | n = 0 for All Responses. Otherwise n= the Classifier No (from the Classifier table) |
| Display a third benchmark made up of all previous responses where the response Classifier = the benchmark Classifier | From "Options" choose Benchmark 3. From "Benchmark 3" select the required group, either All Responses or filtered by Classifier. | BM3=n | n = 0 for All Responses. Otherwise n= the Classifier No (from the Classifier table) |
| Specify the Colors for the chart | From "Options" choose Set the chart colors. In "Set the chart colors" enter the Hex code for the colors, separated by a comma. | Chartcolors=#CCCCCC,#F0F0F0 | Specify the hex code for the colors for the chart, separated by a comma. They will be used in the order they appear. If there are more marks than colors, the defaults will be used. |
| Set the margins. | From 'Options', choose 'Left Margin', 'Right Margin', 'Top Margin', and/or 'Bottom Margin'. Then select an appropriate width in pixels. | MarginLeft=n MarginRight=n MarginTop=n MarginBottom=n | This overrides the defaults in the system, and is useful for either allowing more space (or a consistent space) for axis text, or to remove or reduce the spacing that the chart includes by default. |
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 Specified Role |
| Group responses by Respondent (First name/Last name) | From "Options" choose Set the Cohort Splits. From "Cohort Splits" select Group by Respondent. | SplitType=R | Show the average of responses, grouped by Respondent. |
| Group responses by Classifier | From "Options" choose Set the Cohort Splits. From "Cohort Splits" select Group by Classifier. From "Options" choose Set the Select Classifier. From "Classifier" select Classifier to use. | SplitType=C Class=n | Show the average of responses, grouped by Classifier. N = the classifier Number from the Classifier list. |
| Group responses by Rating | From "Options" choose Set the Cohort Splits. From "Cohort Splits" select Group by Rating. | SplitType=Q | Designed to be used with Counts - to show the number of respondents in each rating. |
| Group responses by Iteration | From "Options" choose Set the Cohort Splits. From "Cohort Splits" select Group by Iteration. | SplitType=T | Show the average of responses, grouped by Iteration. |
| 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. |
| Invert the values in the graph to show bars for the cohort splits rather than the assessment elements. | From "Options" choose Invert. From "Invert" select Invert the Graph. | Invert=Y | Show the Cohort Split as the main division, and the Assessment elements (e.g. sections, subsections etc) as the secondary division of the graph |
| Set the Maximum number of values on a graph, and overflow to another graph, if there a more values | From "Options" choose Set Max. In "Set Maximum" enter the number of main division entries allowed on the graph. | MaxValues=n | If you think you may get more than, say, 20 values (most common when the Cohort Split is by Respondent), set the Maximum Values to start a new chart with the remaining values. |
Examples of Horizontal Bar Multi merge strings:
|
{BarMultiHorizontal[SectionNo=All BM1=0]} |
Horizontal Bar Chart image for a feedback report with a single response and the Benchmark for all previous responses |
|
{BarMultiHorizontal[SectionNo=All SplitType=I]} |
Horizontal Bar Chart image in a cohort report showing each Role for the whole assessment (Bar for each section) |
|
{BarMultiHorizontal[SectionNo=All SplitType=I ShowActual=Y YAxisMax=5 YAxisInc=1]} |
Horizontal Bar Chart image in a cohort report showing each Role for the whole assessment (Bar for each section) - showing actuals, and maximum value on the y-Axis of 5 and an increment of 1.
|
|
{BarMultiHorizontal[SectionNo=2 SubSectionNo=2 SplitType=I]} |
Horizontal Bar Chart image in a cohort report showing each Role by section and subsection (Single Bar) |
|
{BarMultiHorizontal[SectionNo=2 SubSectionNo=All SplitType=I]} |
Horizontal Bar Chart image in a cohort report showing each Role by section and all subsections |
|
{BarMultiHorizontal[SegmentationNo=All SplitType=I]} |
Horizontal Bar Chart image in a cohort report showing each Role by segmentations |
Comments
0 comments
Please sign in to leave a comment.