Pie chart Drill to Children

Hello,

Is there a way to have a dashboard page selection drive the content of a Pie Chart? If in the page selection, "Americas" is selected, have it's immediate children (i.e. USA / Canada) show up in the Pie?

Thank you!

Accepted answers

All comments

PaulRitner

Hi,

Yes! I'm not a master at charts, but here's how I did it:

Assuming a Composite List with Regions as the Parent, and Countries as the child
In the module you want to create the chart in, hide the parent items (e.g. Americas) using a filter. We have to use a filter, because, in order to synchronize, we cannot have hidden rows, or have used the Select Levels To Show, etc.
1. For my example, I created a line item in my chart module and put a 1 in the formula, and set the Summary to None. Then I applied a filter where this line item = 1...and only the lowest level items show.
Publish the Parent list to the dashboard as a selector
Publish your pie chart to the dashboard, and synchronize your countries.

See attached examples.

Cheers!

Chart_example_30298.docx

PaulRitner

Hi,

Yes! I'm not a master at charts, but here's how I did it:

Assuming a Composite List with Regions as the Parent, and Countries as the child
In the module you want to create the chart in, hide the parent items (e.g. Americas) using a filter. We have to use a filter, because, in order to synchronize, we cannot have hidden rows, or have used the Select Levels To Show, etc.
1. For my example, I created a line item in my chart module and put a 1 in the formula, and set the Summary to None. Then I applied a filter where this line item = 1...and only the lowest level items show.
Publish the Parent list to the dashboard as a selector
Publish your pie chart to the dashboard, and synchronize your countries.

See attached examples.

Cheers!

Chart_example_30299.docx

Quick Links

Can you help?

Unanswered questions

3.3.12 Activity: Create Product Replenishment UX Page
Kindly assist me with the below lines. What i need to do first after creating the UX sheet. How to add Product SKU and Time context selectors in the Page. Include the following: Product SKU and Time context selectors. SYS00 Time Settings by Month module, Planning Period Filter for UX saved view (or create a custom view…
How to represent in Anaplan an organizational structure
Hi, is it possible to use a Network Card in order to show an organizational structure which cannot be managed through Hierarchy Lists, cause there are branches that don't have the same hierarchy levels associated? Example: In a L1 COMPANY > L2 AREA > L3 SERVICE > L4 OFFICE There is a case like this: COMPANY A AREA A…
ADO Certification - Cannot Create Migration Link
Hi - I cannot seem to create a migration for Assignment 3 and it will not allow me to update the hierarchy and proceed further. It seems to think that a link has already been created, but I don't see anything. Any ideas?