Articles in this section

See more

Spider Charts

Avatar
Support
  • Updated
Follow

Spider Charts are used to show several sections/ subsections/ questions / segmentations comparatively.  Charts can be either based on percentage scores or the average actual score (Likert style reporting). 

 

Using Percentages Using Likert Scoring
Spider_Chart_1.jpg Spider_Chart_2.jpg
Inverted Values, Split by Identifier Using Rating Bands
Spider_Chart_4.jpg Spider_Chart_3.jpg
Using Rating Lines Using Background Colors or Shading
Spider_Chart_5.jpg Spider_Chart_6.jpg

 

 

 

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.
For a Cohort, show the range of Likert scores in the responses From "Display" select Range Metric=Range The difference between the highest (Likert style) score for the element and the lowest score, within the Cohort.
For a Cohort, show the range of percentage scores in the responses From "Display" select Range % Metric=RangePC The difference between the highest percentage score for the element and the lowest score, within the 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)
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 500 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 500 pixels.
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. 
Display Rating Bands as a background From "Advanced" 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. The ChartColors can be used to set the color of the points.
Display Rating Lines as a background From "Advanced" 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 "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).  
Set the Axis Colors for the chart From "Advanced" choose "Axis Color"
In "Axis Color" enter the  Hex code for the colors, separated by a comma.		 AxisColor=#FFFFFF  
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 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 axis increment of the lines.
Display a benchmark made up of all previous responses where the response Classifier = the benchmark Classifier From "Advanced" 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 "Advanced" 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 "Advanced" 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 "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.
Order Elements by Score ascending (lowest at the top) From "Advanced" choose Sort Type.
From "Sort Type" select Score.
From "Advanced" 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 "Advanced" choose Sort Type.
From "Sort Type" select Score.
From "Advanced" 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 "Advanced" choose Sort Type.
From "Sort Type" select Alphabetical.
From "Advanced" 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 "Advanced" choose Sort Type.
From "Sort Type" select Alphabetical.
From "Advanced" 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 "Advanced" 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 "Advanced" choose Set the Direction.
From "Set the Direction" select Horizontal.		 Direction=Horizontal Displays multiple charts across the page.

Cohort Groupings

Note: Separate Graphs will be shown for each cohort group. 

  • To show the cohort groups on one chart, use the Multi Vertical Bar merge type.
  • Use the Invert parameter to use the Cohort split grouping to populate the graph.  For example, to show the individual respondent scores for the assessment, or a single section, subsection, question, or segmentation.
  • When using the Invert parameter, consider using the MaxValues parameter in cases where the number of values shown is unpredictable.
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 Iteration From "Advanced" 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 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.
Filter the data to only use the first Iteration From "Advanced" 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 "Advanced" 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 "Advanced" 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 element. From "Advanced" choose Invert.
From "Invert" select Invert the Graph.		 Invert=Y Show the Cohort Split as the bars, and the Assessment element (if there are more than one) as separate graphs
Set the Maximum number of values on a graph, and overflow to another graph, if there a more values From "Advanced" choose Set Max.
In "Set Maximum" enter the number of points 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.  Note that any sort is executed first, so the charts will retain the sort order.

 Examples of Spider merge strings:

{Spider[SectionNo=All]}

Spider image for the whole assessment (Point for each section)

{Spider[SectionNo=2 SubSectionNo=All Label=Y]}

Spider image by section and all subsections (Point for each Subsection) and display labels.

{Spider[SectionNo=2 SubSectionNo=All ShowActual=Y Label=Y Decimals=1]}

Spider image for section 2 and all subsections (Point for each Subsection) displaying average actual points to one decimal point (Likert Style) and displaying labels.

{Spider[SegmentationNo=All]}

Spider Chart image by segmentations

 

Related articles

Comments

0 comments

Please sign in to leave a comment.