Spider Charts

Spider charts, also called radar charts, are a two-dimensional chart type designed to plot one or more series of values over multiple common quantitative variables by providing an axis for each variable, arranged as spokes around a central point. The values for adjacent variables in a single series are connected by lines. Frequently the shape created by these lines is filled in with color.

In Jaspersoft Studio, spider charts are in a separate element from the rest of the charts available in the Community Project. This is because they are a separate component in JasperReports Library. However, you use them the same way you use other JFree Charts.

To filter your data in a Spider Chart, you must filter it in the Dataset and Query dialog.

To create the report for the chart:

1. Open a new, blank report using a landscape template and the Sugar CRM database. Use the following query:

select * from orders

Click Next.

2. Move all the fields into the right-hand box. Click Next.
3. No need to group by any field. Click Finish.
4. Right-click on each band in the outline view, and choose Delete to delete all bands except for Title and Summary.
5. Drag a Static Text element into the title bar, and name your report something like “Employee Orders by Month and Country”.
6. Enlarge the Summary band to 350 pixels by changing the Height entry in the Band Properties view.

To create a spider chart:

1. Drag the Spider Chart element from the Palette into your report.

Spider Chart

2. Select the report in the Outline view, and in the Properties tab, click the Edit query, filter, and sort options button.

The Dataset and Query dialog opens.

Filter Expression for Spider Chart

3. To filter data so that the chart is more readable, click the Filter Expression tab and add the following expression:

( $F{shipcountry}.startsWith("N") || $F{shipcountry}.startsWith("M") || $F{shipcountry}.startsWith ("U") || $F{shipcountry}.startsWith ("I") ) || $F{shipcountry}.startsWith("A") && ( $F{shipname}.startsWith( "M" ) || $F{shipname}.startsWith( "A" ) || $F{shipname}.startsWith( "G" ) )

Do not include any manual line breaks.

Click OK.

4. Double-click the chart. The Chart Data Configuration dialog opens.
5. Click the Series button and create the series $F{employeeid}.
6. Click the Value button and create the value MONTH($F{orderdate}).
7. Click the Category button and create the category $F{shipcountry}.
8. Click Finish.

To customize the look of your chart:

1. Single-click your chart, and click the Properties view.
2. In the Legend category, set the drop-down menu for Show Legend to True.
3. Use the Position drop-down, to move the legend to the left.
4. Drag a Static Text element just to the left and above the legend. Label the legend Employee Number.
5. Save your report. The Design view should look like the following:

Spider Chart Design

6. Preview your report. It should look like the following:

Spider Chart Preview