How to create Pie Chart in Performance Analytics

[Community Alums]

Hi, I need help on how to create Pie Chart that has breakdown by Country based on the Company Field (Company field is a reference field (Company table) that has Country in it) in Performance Analytics. I can't find any example in the Wiki nor in the OOB configuration).

Advanced thanks!

rohaNa.

[Abhishek Choudh]

Hi,

Open your PA table in list view (ensure Company field is pulled in the list view) and right click on Company header column ->   select pie chart. After pie chart opens up select as Group by field as stated and shown below -

1) Company => Company fields

2) Country

see below screenshot -

[Community Alums]

Hi Abhishek, thanks but I'm talking about creating pie chart in Performance Analytics > widget module. The one that you're pointing is in Reporting module.

[Arnoud Kooi]

Out of Box country field on Location table is a string field, I would suggest to add a custom Country field u_country as a Reference to the core_country table.

Hide the OOB country field from your form and list.

After that do the following:

• Create a breakdown source with Country [core_country] as facts table
• Create a breakdown Country based on the new breakdown source
• Create one or more breakdownmapping for example to incident this way (dotwalk to the country reference field):

• After this, add this breakdown to the Indicator(s) you want to use it in
• Create or   edit your widget

• Collect the data and review your widget

[Community Alums]

Hi Arnoud,

Many thanks for the guide. I've configured all the required in your steps but the pie chart is not populated. Where should look if there is missing configuration?

FYI, I've played around all the settings but the chart is still not populating. Any further help is highly appreciated!

rm,