A custom Pie Chart add-on for BusinessObjects Dashboards 4.0 SP3 or higher

[arijit_das]

Here is another interesting add-on for BusinessObjects Dashboards 4.0 - a custom pie chart. In my working experience, many times, I did face the requirement of a doughnut chart and exploding a pie wedge while drill-down. So, I have created an add-on for the same in flex with dashboards sdk which I am sharing here.

Features:

General Tab

In this tab, there are options to

• bind the labels and values of the pie chart to excel range.
• insert selected label and value to excel.

Note:	Records with blank values in label or data are ignored. If no item is selected, NaN is inserted as value. Once selected, an item can be deselected by clicking the exploded wedge.

Behavior Tab

In this tab, there are options for:

• Dynamic visibility: Setup dynamic visibility of the component.
• Negative value handling: Show negative values as absolute in pie chart or do not show the record at all.
• Top N and Others: It is possible to show top N records and group other records as 'Others' in the chart.
  

Note:	If show negative values as absolute is selected, negative data is displayed as positive in chart, though, data is inserted as negative while drill-down.

Appearance Tab

In this tab, there are options to:

• vary inner radius to create a doughnut chart.
• bind colors of the pie wedges to an excel cell range.
• show or hide border.
• select border color.
• select background color.
• select position and font of the legend.

Note:	Wedge colors can be a flex-supported color name or a valid hex color code. If it is not, then black will be selected. It is recommended to select a color range larger than or equal to the range of labels. Otherwise the colors will be repeated.

How does it look like in canvas

Without drill-down

After drill-down

Showing top 3 and Others

A Doughnut Chart

Showing data on mouse hover

Custom background and border color

Download

The full flex project along with the add-on(xlx) file is available here for download.

For more interesting add-ons, visit the wiki page SAP BusinessObjects Dashboards 4.0 Add-On Gallery.

Happy dashboarding :smile: