Spider charts (or radar charts) are two-dimensional charts designed to plot 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 separate from the rest of the charts available in the Community Project, because they're a separate component in JasperReports Library. But you use them just as other JFree Charts.
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 box. Click Next and Finish. |
| 3. | Delete all bands except Title and Summary. |
| 4. | Drag a Static Text element into the title bar, and name your report something like “Employee Orders by Month and Country”. |
| 5. | 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 |
|
| To filter your data in a Spider Chart, you must filter it in the Dataset and Query dialog. |
| 3. | To filter data for a more readable chart, click the Filter Expression tab and enter the expression below with no manual line breaks, then click OK. |
( $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" ) )
| 4. | Double-click the chart to display the Chart Data Configuration dialog. |
| 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}. |
To customize the look of your chart:
| 1. | Single-click your chart, and click the Properties tab. |
| 2. | Click the Legend category and select True in the Show Legend drop-down menu. |
| 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 figure. |
Spider Chart Design |
|
| 6. | Preview your report. It should look like the following: |
Spider Chart Preview |
|
Recommended Comments
There are no comments to display.