Stacked Bar and Column Charts are specifically designed for, and only available for reporting counts of responses in a cohort, split by Rating.
Normally you will need to set up a Rating Type (using advanced ratings) to overlay the answer scores, either exactly, or with groupings. In the example below, we set up three ratings
- A rating named Always/Usually with a maximum of 100% - Always will be 100% and Usually 80%
- A Rating named Sometimes with a maximum of 60%. Sometimes will always be 60%.
- A Rating named Never/Occasionally with a maximum of 40%. Occasionally will be 40% and Never 20%.
If you want to separate all of the answers (in a Likert scored question) you would have 5 ratings with a maximum of 100%,80%,60%,40%, and 20%.
When creating the merge string in the Cohort report, it must include (from the list below):
- the Rating Type created for the ratings.
- Cohort Split Type=Rating
- Metric=Count or CountPC.
Below is an example of a Stacked Bar using the above structure.
A note regarding 360's
Often in 360's you have two versions of every question, one for the subject, and one for the people rating the subject. Reporting by Question will show both questions.
A workaround for this is to use Segmentations. You would name the segmentation after the Question, and Group them by a Group named after the Subsection. Both related questions would be linked to the segmentation. The Report will, instead of being for the questions, be for segmentations, filtered by the Subsection named Segmentation Group. They will appear exactly the same on the report.
|
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 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 |
|
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 "Advanced" 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 "Advanced" 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) |
| Select the Font for the Legends and Labels | From "Advanced" 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 "Advanced" choose Font Size. In "Font Size" enter the required font size in points. |
FontSize=n | n = the font size in points. |
| Select the Background color for the chart, or make it transparent | From "Advanced" 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. |
| Set the Label Color | From "Advanced" 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). |
| Don't show the Title | From "Advanced" choose Title Rules. From "Title Rules" select None. |
Title=N | No Title is shown (this is the section / subsection / question / answer name shown under/beside each bar) |
| Don't show the Y-Axis | From "Advanced" 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 height of the graphic (overriding the default) |
From "Advanced" 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 "Advanced" 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. |
|
Set the maximum value of the Score Axis. |
From "Advanced" 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 "Advanced" 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. |
|
Specify the Colors for the chart |
From "Advanced" 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. |
Cohort Groupings |
|||
|
How to |
Using the Merge Manager |
Parameter |
Notes |
|
Group all the responses into one result |
From "Advanced" choose Set the Cohort Splits. From "Cohort Splits" select Average all Responses. |
SplitType=N |
No Split |
|
Group responses by Reporting Identifier (or Role if using Cohort Initiations) |
From "Advanced" choose Set the Cohort Splits. From "Cohort Splits" select Group by Report Identifier. |
SplitType=I |
Show the average of responses, grouped by Report Identifier or the Specified Identifier |
|
Group responses by Respondent (First name/Last name) |
From "Advanced" 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 "Advanced" choose Set the Cohort Splits. From "Cohort Splits" select Group by Classifier. From "Advanced" 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 "Advanced" 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 Month and Year |
From "Advanced" 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 "Advanced" 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 Identifier |
From "Advanced" choose Filter by Identifier. In "Identifier" enter the Reporting Identifier to use.. |
Identifier=nnnnnn |
Filter the data to only use the specified Reporting Identifier (Often the Role if using Cohort Initiations). If the Reporting Identifier has spaces, replace them with an underscore. |
Comments
0 comments
Please sign in to leave a comment.