topic Re: Pie of Pie chart in Discussions

Pie of Pie chart

TWE — Wed, 20 Mar 2019 13:23:01 GMT

Hi,

is there a way to generate a pie chart (pie or bar of pie chart) like the following one?

https://www.officetooltips.com/excel_2016/tips/creating_pie_of_pie_and_bar_of_pie_charts.html

Thanks

Re: Pie of Pie chart

danschikore — Wed, 20 Mar 2019 14:42:42 GMT

I don't think that these composite plots are built-in to JMP, but you can create something similar by combining reports. It might be helpful to create an ID column to designate which rows should be combined together. For the effect of pie-in-pie, this could mean copying your category column and changing some of them to "Other", or it could be more general if there are other meaningful groups.

Once you create two graphs (one using the ID column, one using the full category columns), you can use Combine Windows to merge them together, and choose the ID column as a Selection Filter. Below is what I get using age as the grouping column with the Big Class sample data. With 16-year-olds selected on the left, the individual 16's are shown on the right.

One advantage of using selection filters is that the behavior is dynamic - you can select any category on the left and the plot on the right will update. You can also select multiple categories, so if you want to see 12- and 13-year-olds in one plot, you can select them both. You are also not limited to Pies and Bars - you can use any JMP reports that work for your data.

There are more selection filter examples in . This article uses Application Builder to create the report, but starting in JMP 13 the functionality is built directly into Combine Windows.

Re: Pie of Pie chart

TWE — Thu, 21 Mar 2019 14:08:42 GMT

Thanks, this should work!

Re: Pie of Pie chart

Mo — Tue, 24 Sep 2019 13:39:23 GMT

Question: how did you get the thicker line around the one segment (to highlight)?

Re: Pie of Pie chart

danschikore — Tue, 24 Sep 2019 13:54:23 GMT

The pie segment is outlined based on the preference for how to draw selected areas:

I have attached PieFilter.jmpapp if you would like to try it out. The app is configured to automatically run on $SAMPLE_DATA/Big Class.jmp.

Re: Pie of Pie chart

nascif_jmp — Fri, 06 Nov 2020 19:54:43 GMT

Since JMP 15.0, you can accomplish the same task using Graphlets and their pre-configured presets.

By pinning the hover labels with pie charts for different slices, you can also compare the result of different paths of your drill-down analysis (and you can launch these pie charts as new graphs for an even better comparison).

The screenshot below shows an example: