cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

JMP Wish List

We want to hear your ideas for improving JMP. Share them here.
%3CLINGO-SUB%20id%3D%22lingo-sub-247843%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E3%82%B0%E3%83%A9%E3%83%95%E3%83%93%E3%83%AB%E3%83%80%E3%83%BC%E5%86%85%E3%81%AE%E3%83%92%E3%82%B9%E3%83%88%E3%82%B0%E3%83%A9%E3%83%A0%E3%81%AB%E3%83%90%E3%83%BC%E3%82%B9%E3%82%BF%E3%82%A4%E3%83%AB%E3%82%92%E8%BF%BD%E5%8A%A0%E3%81%97%E3%81%BE%E3%81%99%E3%80%82%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-247843%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E7%A9%8D%E3%81%BF%E4%B8%8A%E3%81%92%E3%80%81%E6%A8%AA%E4%B8%A6%E3%81%B3%E3%80%81%E5%85%A5%E3%82%8C%E5%AD%90%E3%81%AA%E3%81%A9%E3%80%81%E3%82%B0%E3%83%A9%E3%83%95%E3%83%93%E3%83%AB%E3%83%80%E3%83%BC%E5%86%85%E3%81%AE%E3%83%92%E3%82%B9%E3%83%88%E3%82%B0%E3%83%A9%E3%83%A0%E3%81%A7%E3%83%90%E3%83%BC%E3%81%8C%E3%81%A9%E3%81%AE%E3%82%88%E3%81%86%E3%81%AB%E8%A1%A8%E7%A4%BA%E3%81%95%E3%82%8C%E3%82%8B%E3%81%8B%E3%82%92%E5%A4%89%E6%9B%B4%E3%81%99%E3%82%8B%E3%82%AA%E3%83%97%E3%82%B7%E3%83%A7%E3%83%B3%E3%82%92%E8%BF%BD%E5%8A%A0%E3%81%97%E3%81%BE%E3%81%99%E3%80%82%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E3%82%AB%E3%82%A6%E3%83%B3%E3%83%88%E7%B5%B1%E8%A8%88%E3%81%AE%E6%A3%92%E3%82%B0%E3%83%A9%E3%83%95%E3%82%92%E4%BD%BF%E7%94%A8%E3%81%99%E3%82%8B%E5%BF%85%E8%A6%81%E3%81%AF%E3%81%AA%E3%81%8F%E3%80%81%E3%83%92%E3%82%B9%E3%83%88%E3%82%B0%E3%83%A9%E3%83%A0%E3%81%8B%E3%82%89%E5%A7%8B%E3%82%81%E3%81%A6%E3%81%93%E3%81%AE%E3%82%B0%E3%83%A9%E3%83%95%E3%82%92%E4%BD%9C%E6%88%90%E3%81%99%E3%82%8B%E6%96%B9%E3%81%8C%E7%9B%B4%E6%84%9F%E7%9A%84%E3%81%A7%E3%81%99%E3%80%82%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Binned.png%22%20style%3D%22width%3A%20680px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Binned.png%22%20style%3D%22width%3A%20680px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F21777iAA3AAC5C31080198%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Binned.png%22%20alt%3D%22Binned.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E3%81%82%E3%81%AA%E3%81%9F%E3%81%8C%E5%BE%97%E3%82%8B%E6%9C%80%E3%82%82%E8%BF%91%E3%81%84%E3%82%82%E3%81%AE%E3%81%AF%E3%82%AA%E3%83%BC%E3%83%90%E3%83%BC%E3%83%AC%E3%82%A4%E3%81%95%E3%82%8C%E3%81%9F%E3%83%90%E3%83%BC%E3%81%A7%E3%81%99%EF%BC%9A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Histogram.png%22%20style%3D%22width%3A%20654px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Histogram.png%22%20style%3D%22width%3A%20654px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F21778i3DF606E21A2692B7%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Histogram.png%22%20alt%3D%22Histogram.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E3%82%B3%E3%83%BC%E3%83%89%EF%BC%9A%3C%2FP%3E%3CDIV%20class%3D%22lia-spoiler-container%22%3E%3CA%20class%3D%22lia-spoiler-link%22%20href%3D%22%23%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%20target%3D%22_blank%22%3E%E3%82%82%E3%81%A3%E3%81%A8%E8%A6%8B%E3%82%8B...%20%3C%2FA%3E%3CNOSCRIPT%3E%3CDIV%20class%3D%22lia-spoiler-content%22%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20default%20to%20here(1)%3B%0A%0Adt%20%3D%20Open(%20%22%24Sample_Data%2Firis.jmp%22%20)%3B%0A%0Adt%20%26lt%3B%26lt%3B%20New%20Column(%22Sepal%20length%20Binned%22%2C%20Numeric%2C%20%22Continuous%22%2C%20Format(%22Fixed%20Dec%22%2C%2012%2C%201)%2C%20Formula(Floor(%3ASepal%20length%20%2F%200.2)%20*%200.2))%3B%0Adt%20%26lt%3B%26lt%3B%20New%20Column(%22Is%20Target%22%2C%20Character%2C%20%22Nominal%22%2C%20Set%20Property(%22Value%20Colors%22%2C%20%7B%22Is%20Target%22%20%3D%2059%2C%20%22The%20Rest%22%20%3D%2032%7D)%2C%20Formula(If(%3ASpecies%20%3D%3D%20%22setosa%22%2C%20%22Is%20Target%22%2C%20%22The%20Rest%22)))%3B%0A%0A%2F%2FDesired%20Chart%0Adt%20%26lt%3B%26lt%3B%20Graph%20Builder(%0A%20Size(%20500%2C%20300%20)%2C%0A%20Show%20Control%20Panel(%200%20)%2C%0A%20Variables(%0A%20%20X(%20%3ASepal%20length%20)%2C%0A%20%20Y(%20%3ASepal%20length%20)%2C%0A%20%20Overlay(%20%3AIs%20Target%20)%2C%0A%20%20Color(%20%3AIs%20Target%20)%0A%20)%2C%0A%20Elements(%0A%20%20Bar(%20X%2C%20Y%2C%20Legend(%2011%20)%2C%20Bar%20Style(%20%22Stacked%22%20)%2C%20Summary%20Statistic(%20%22N%22%20)%20)%0A%20)%2C%0A%20SendToReport(%0A%20%20Dispatch(%0A%20%20%20%7B%7D%2C%0A%20%20%20%22Sepal%20length%22%2C%0A%20%20%20ScaleBox%2C%0A%20%20%20%7BMin(%204.1659880239521%20)%2C%20Max(%208.0340119760479%20)%2C%20Inc(%200.2%20)%2C%0A%20%20%20Minor%20Ticks(%200%20)%7D%0A%20%20)%0A%20)%0A)%3B%0A%0A%2F%2FHistogram%20option%20-%20no%20way%20to%20stack%20bars%2C%20leads%20to%20confusion%20when%20'Is%20Target'%20%0A%2F%2Fand%20'The%20rest'%20have%20similar%20counts%0Adt%20%26lt%3B%26lt%3B%20Graph%20Builder(%0A%20Size(%20500%2C%20300%20)%2C%0A%20Show%20Control%20Panel(%200%20)%2C%0A%20Variables(%0A%20%20X(%20%3ASepal%20length%20)%2C%0A%20%20Y(%20%3ASepal%20length%20)%2C%0A%20%20Overlay(%20%3AIs%20Target%20)%2C%0A%20%20Color(%20%3AIs%20Target%20)%0A%20)%2C%0A%20Elements(%20Histogram(%20X%2C%20Y%2C%20Legend(%2012%20)%20)%20)%2C%0A%20SendToReport(%0A%20%20Dispatch(%0A%20%20%20%7B%7D%2C%0A%20%20%20%22Sepal%20length%22%2C%0A%20%20%20ScaleBox%2C%0A%20%20%20%7BMin(%204.1659880239521%20)%2C%20Max(%208.0340119760479%20)%2C%20Inc(%200.2%20)%2C%0A%20%20%20Minor%20Ticks(%200%20)%7D%0A%20%20)%0A%20)%0A)%3B%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FDIV%3E%3CNOSCRIPT%3E%3CDIV%20class%3D%22lia-spoiler-noscript-content%22%3E%E5%90%8D%E5%89%8D%E3%81%AE%E3%83%87%E3%83%95%E3%82%A9%E3%83%AB%E3%83%88%E3%81%AFhere%EF%BC%881%EF%BC%89%3B%E3%81%A7%E3%81%99%E3%80%82%0A%0Adt%20%3D%20Open%EF%BC%88%20%22%24%20Sample_Data%20%2F%20iris.jmp%22%EF%BC%89%3B%0A%0Adt%20%26lt%3B%26lt%3B%20New%20Column%EF%BC%88%20%22Sepal%20length%20Binned%22%E3%80%81Numeric%E3%80%81%22Continuous%22%E3%80%81Format%EF%BC%88%20%22Fixed%20Dec%22%E3%80%8112%E3%80%811%EF%BC%89%E3%80%81Formula%EF%BC%88Floor%EF%BC%88%EF%BC%9ASepal%20length%20%2F%200.2%EF%BC%89*%200.2%EF%BC%89%EF%BC%89%3B%0Adt%20%26lt%3B%26lt%3B%20New%20Column%EF%BC%88%20%22Is%20Target%22%E3%80%81Character%E3%80%81%22Nominal%22%E3%80%81Set%20Property%EF%BC%88%20%22Value%20Colors%22%E3%80%81%7B%22Is%20Target%22%20%3D%2059%E3%80%81%22The%20Rest%22%20%3D%2032%7D%EF%BC%89%E3%80%81Formula%EF%BC%88If%EF%BC%88%EF%BC%9ASpecies%20%3D%3D%20%E3%80%8Csetosa%E3%80%8D%E3%80%81%E3%80%8CIs%20Target%E3%80%8D%E3%80%81%E3%80%8CThe%20Rest%E3%80%8D%EF%BC%89%EF%BC%89%EF%BC%89%3B%0A%0A%2F%2F%E5%BF%85%E8%A6%81%E3%81%AA%E3%83%81%E3%83%A3%E3%83%BC%E3%83%88%0Adt%20%26lt%3B%26lt%3B%E3%82%B0%E3%83%A9%E3%83%95%E3%83%93%E3%83%AB%E3%83%80%E3%83%BC%EF%BC%88%0A%20%E3%82%B5%E3%82%A4%E3%82%BA%EF%BC%88500%E3%80%81300%EF%BC%89%E3%80%81%0A%20%E3%82%B3%E3%83%B3%E3%83%88%E3%83%AD%E3%83%BC%E3%83%AB%E3%83%91%E3%83%8D%E3%83%AB%E3%82%92%E8%A1%A8%E7%A4%BA%EF%BC%880%EF%BC%89%E3%80%81%0A%20%E5%A4%89%E6%95%B0%EF%BC%88%0A%20%20X%EF%BC%88%EF%BC%9A%E3%81%AF%E3%81%8C%E3%81%8D%E9%95%B7%E3%81%95%EF%BC%89%E3%80%81%0A%20%20Y%EF%BC%88%EF%BC%9A%E3%81%AF%E3%81%8C%E3%81%8D%E9%95%B7%E3%81%95%EF%BC%89%E3%80%81%0A%20%20Overlay%EF%BC%88%EF%BC%9AIs%20Target%EF%BC%89%E3%80%81%0A%20%20%E8%89%B2%EF%BC%88%EF%BC%9A%E3%82%BF%E3%83%BC%E3%82%B2%E3%83%83%E3%83%88%E3%81%A7%E3%81%99%EF%BC%89%0A%20%EF%BC%89%E3%80%81%0A%20%E8%A6%81%E7%B4%A0%EF%BC%88%0A%20%20%E6%A3%92%EF%BC%88X%E3%80%81Y%E3%80%81%E5%87%A1%E4%BE%8B%EF%BC%8811%EF%BC%89%E3%80%81%E6%A3%92%E3%82%B9%E3%82%BF%E3%82%A4%E3%83%AB%EF%BC%88%E3%80%8C%E7%A9%8D%E3%81%BF%E4%B8%8A%E3%81%92%E3%80%8D%EF%BC%89%E3%80%81%E8%A6%81%E7%B4%84%E7%B5%B1%E8%A8%88%E9%87%8F%EF%BC%88%E3%80%8CN%E3%80%8D%EF%BC%89%EF%BC%89%0A%20%EF%BC%89%E3%80%81%0A%20SendToReport%EF%BC%88%0A%20%20%E3%83%87%E3%82%A3%E3%82%B9%E3%83%91%E3%83%83%E3%83%81%EF%BC%88%0A%20%20%20%7B%7D%E3%80%81%0A%20%20%20%22%E3%81%8C%E3%81%8F%E7%89%87%E3%81%AE%E9%95%B7%E3%81%95%22%E3%80%81%0A%20%20%20ScaleBox%E3%80%81%0A%20%20%20%7B%E6%9C%80%E5%B0%8F%EF%BC%884.1659880239521%EF%BC%89%E3%80%81%E6%9C%80%E5%A4%A7%EF%BC%888.0340119760479%EF%BC%89%E3%80%81Inc%EF%BC%880.2%EF%BC%89%E3%80%81%0A%20%20%20%E5%89%AF%E7%9B%AE%E7%9B%9B%E3%82%8A%EF%BC%880%EF%BC%89%7D%0A%20%20%EF%BC%89%0A%20%EF%BC%89%0A%EF%BC%89%3B%0A%0A%2F%2F%E3%83%92%E3%82%B9%E3%83%88%E3%82%B0%E3%83%A9%E3%83%A0%E3%82%AA%E3%83%97%E3%82%B7%E3%83%A7%E3%83%B3-%E3%83%90%E3%83%BC%E3%82%92%E3%82%B9%E3%82%BF%E3%83%83%E3%82%AF%E3%81%99%E3%82%8B%E6%96%B9%E6%B3%95%E3%81%8C%E3%81%AA%E3%81%84%E3%81%9F%E3%82%81%E3%80%81%E3%80%8C%E3%82%BF%E3%83%BC%E3%82%B2%E3%83%83%E3%83%88%E3%80%8D%E3%81%AE%E5%A0%B4%E5%90%88%E3%81%AB%E6%B7%B7%E4%B9%B1%E3%82%92%E6%8B%9B%E3%81%8F%20%0A%2F%2F%E3%80%8C%E6%AE%8B%E3%82%8A%E3%80%8D%E3%82%82%E5%90%8C%E6%A7%98%E3%81%AE%E6%95%B0%0Adt%20%26lt%3B%26lt%3B%E3%82%B0%E3%83%A9%E3%83%95%E3%83%93%E3%83%AB%E3%83%80%E3%83%BC%EF%BC%88%0A%20%E3%82%B5%E3%82%A4%E3%82%BA%EF%BC%88500%E3%80%81300%EF%BC%89%E3%80%81%0A%20%E3%82%B3%E3%83%B3%E3%83%88%E3%83%AD%E3%83%BC%E3%83%AB%E3%83%91%E3%83%8D%E3%83%AB%E3%82%92%E8%A1%A8%E7%A4%BA%EF%BC%880%EF%BC%89%E3%80%81%0A%20%E5%A4%89%E6%95%B0%EF%BC%88%0A%20%20X%EF%BC%88%EF%BC%9A%E3%81%AF%E3%81%8C%E3%81%8D%E9%95%B7%E3%81%95%EF%BC%89%E3%80%81%0A%20%20Y%EF%BC%88%EF%BC%9A%E3%81%AF%E3%81%8C%E3%81%8D%E9%95%B7%E3%81%95%EF%BC%89%E3%80%81%0A%20%20Overlay%EF%BC%88%EF%BC%9AIs%20Target%EF%BC%89%E3%80%81%0A%20%20%E8%89%B2%EF%BC%88%EF%BC%9A%E3%82%BF%E3%83%BC%E3%82%B2%E3%83%83%E3%83%88%E3%81%A7%E3%81%99%EF%BC%89%0A%20%EF%BC%89%E3%80%81%0A%20Elements%EF%BC%88Histogram%EF%BC%88X%E3%80%81Y%E3%80%81Legend%EF%BC%8812%EF%BC%89%EF%BC%89%EF%BC%89%E3%80%81%0A%20SendToReport%EF%BC%88%0A%20%20%E3%83%87%E3%82%A3%E3%82%B9%E3%83%91%E3%83%83%E3%83%81%EF%BC%88%0A%20%20%20%7B%7D%E3%80%81%0A%20%20%20%22%E3%81%8C%E3%81%8F%E7%89%87%E3%81%AE%E9%95%B7%E3%81%95%22%E3%80%81%0A%20%20%20ScaleBox%E3%80%81%0A%20%20%20%7B%E6%9C%80%E5%B0%8F%EF%BC%884.1659880239521%EF%BC%89%E3%80%81%E6%9C%80%E5%A4%A7%EF%BC%888.0340119760479%EF%BC%89%E3%80%81Inc%EF%BC%880.2%EF%BC%89%E3%80%81%0A%20%20%20%E5%89%AF%E7%9B%AE%E7%9B%9B%E3%82%8A%EF%BC%880%EF%BC%89%7D%0A%20%20%EF%BC%89%0A%20%EF%BC%89%0A%EF%BC%89%3B%3C%2FDIV%3E%3C%2FNOSCRIPT%3E%3C%2FNOSCRIPT%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-247843%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CLINGO-LABEL%3E%E3%82%B0%E3%83%A9%E3%83%95%E3%82%A3%E3%83%83%E3%82%AF%E3%82%B9%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Choose Language Hide Translation Bar
0 Kudos

Add bar style to histogram within graph builder.

Add options to change how bars are displayed on histograms within graph builder, including stacked, side by side, nested, etc.

 

Users would find it more intuitive to build this chart by starting with a histogram rather than needing to use a bar chart with a count statistic:

Binned.png

 

but the closest you get are overlaid bars:

Histogram.png

 

Code:

View more...
Names default to here(1);

dt = Open( "$Sample_Data/iris.jmp" );

dt << New Column("Sepal length Binned", Numeric, "Continuous", Format("Fixed Dec", 12, 1), Formula(Floor(:Sepal length / 0.2) * 0.2));
dt << New Column("Is Target", Character, "Nominal", Set Property("Value Colors", {"Is Target" = 59, "The Rest" = 32}), Formula(If(:Species == "setosa", "Is Target", "The Rest")));

//Desired Chart
dt << Graph Builder(
	Size( 500, 300 ),
	Show Control Panel( 0 ),
	Variables(
		X( :Sepal length ),
		Y( :Sepal length ),
		Overlay( :Is Target ),
		Color( :Is Target )
	),
	Elements(
		Bar( X, Y, Legend( 11 ), Bar Style( "Stacked" ), Summary Statistic( "N" ) )
	),
	SendToReport(
		Dispatch(
			{},
			"Sepal length",
			ScaleBox,
			{Min( 4.1659880239521 ), Max( 8.0340119760479 ), Inc( 0.2 ),
			Minor Ticks( 0 )}
		)
	)
);

//Histogram option - no way to stack bars, leads to confusion when 'Is Target' 
//and 'The rest' have similar counts
dt << Graph Builder(
	Size( 500, 300 ),
	Show Control Panel( 0 ),
	Variables(
		X( :Sepal length ),
		Y( :Sepal length ),
		Overlay( :Is Target ),
		Color( :Is Target )
	),
	Elements( Histogram( X, Y, Legend( 12 ) ) ),
	SendToReport(
		Dispatch(
			{},
			"Sepal length",
			ScaleBox,
			{Min( 4.1659880239521 ), Max( 8.0340119760479 ), Inc( 0.2 ),
			Minor Ticks( 0 )}
		)
	)
);
1 Comment
Ryan_Gilmore
Community Manager
Status changed to: Archived
We are archiving this request. If this is still important please comment with additional details and we will reopen. Thank you!