Percentual plot

[#1]

Hello everybody,

I plotted some data and divided the plot into two parts. One for "good" and one for "bad" - green and red columns.

Is there a possibility to add a third part in the plot which displays the percentual "bad" values for the total values of the x-axis? See Images attached.

Thank you.

[#2 · Accepted solution]

You can do what you want, but you will need to change your data a little.  You need to split your data into ji and nein columns

     Tables=>Split

and then bring up Graph Builder.  In the Graph Builder, right click on the new ji or nein column and create a new transform formula column.  Use the following formula to create the percent values for the transform column

( ji + nein ) / nein

Then in the Graph Builder window drag in your X column.  Then drag in the nein column to the Y axis.  Next drag in the ji column to the bottom of the Y axis, adding it in as a separate graph, and finally, drag in the percent column to the bottom of the Y axis. You can adjust each of the Y axes as you want.  

Below is a simple example using the supplied Big Class sample data table.

and the JSL to produce the graph

Graph Builder(
	Size( 534, 450 ),
	Show Control Panel( 0 ),
	Variables(
		X( :age ),
		Y( :height ),
		Y( :weight ),
		Y(
			Transform Column(
				"Percent",
				Formula( ((:weight + :height) / :weight) * 1 )
			)
		)
	),
	Elements( Position( 1, 1 ), Bar( X, Y, Legend( 35 ) ) ),
	Elements( Position( 1, 2 ), Bar( X, Y, Legend( 34 ) ) ),
	Elements( Position( 1, 3 ), Bar( X, Y, Legend( 33 ) ) ),
	SendToReport(
		Dispatch(
			{},
			"height",
			ScaleBox,
			{Min( 0 ), Max( 125 ), Inc( 20 ), Minor Ticks( 0 )}
		),
		Dispatch(
			{},
			"Percent",
			ScaleBox,
			{Format( "Percent", 9, 1 ), Min( 0 ), Max( 4 ), Inc( 0.5 ),
			Minor Ticks( 1 )}
		),
		Dispatch(
			{},
			"400",
			ScaleBox,
			{Legend Model(
				35,
				Properties( 0, {Fill Color( 19 )}, Item ID( "Mean(height)", 1 ) )
			), Legend Model(
				34,
				Properties( 0, {Fill Color( 20 )}, Item ID( "Mean(weight)", 1 ) )
			), Legend Model(
				33,
				Properties( 0, {Fill Color( 9 )}, Item ID( "Mean(Percent)", 1 ) )
			)}
		),
		Dispatch(
			{},
			"400",
			LegendBox,
			{Legend Position( {35, [2], 34, [1], 33, [0]} ), Position( {2, 1, 0} )}
		)
	)
)