topic Re: Graph builder overlay question in Discussions

Graph builder overlay question

john_madden — Mon, 16 Apr 2018 01:13:08 GMT

Hi,

I would like to build a graph from a table that is like this:

User	Event	Frequency
A	W	2
A	X	1
B	X	3
B	Y	!
C	Z	2
D	X	2
E	Z	3
…	…	…

I want the graph to be two side-by-side bar graphs. The X-axis will be Event.

The left pane should show % of each event type for the group of all users (i.e. numerators are number of each event tyoe for all users, denominator is all events of all users).

The right pane should show % of each event type for one specific user (i.e. numerators are number of each event type for specific user, denominator is all events of specific user).

Ultimatly, I want to produce a separate graph like this for each user. Thus, the left pane would be the same for each graph; the right pane would be specific to one user at a time.

I'm having problems figuring out how to do this. Would appreciate some help.

John

Re: Graph builder overlay question

Byron_JMP — Mon, 16 Apr 2018 02:16:57 GMT

Good questions about graphing.

Frequency needs contain data that are Numeric, and continuous (little blue triangle icon)

Event and User are Nominal, already.

Drag User to the x axis, and then drag Even to the right hand side of the x-axis

Drag Freqency into the frequency role on the botton right hand corner of the graphbuilder box

Choose the Bar chart element from the top of the graphbuilder box

Then on the left hand pannel, the Elements pannel, change the statistic from Mean to % of total

Just in case that didn't make sense, copy the following script into a script window and run it, when your example table is the primary table.

Graph Builder(
	Size( 393, 201 ),
	Show Control Panel( 0 ),
	Show Legend( 0 ),
	Variables( X( :User ), X( :Event ), Frequency( :Frequency ) ),
	Elements(
		Position( 1, 1 ),
		Bar( X, Legend( 20 ), Summary Statistic( "% of Total" ) )
	),
	Elements(
		Position( 2, 1 ),
		Bar( X, Legend( 21 ), Summary Statistic( "% of Total" ) )
	),
	SendToReport( Dispatch( {}, "", ScaleBox, {Min( 0 )} ) )
);

Re: Graph builder overlay question

john_madden — Mon, 16 Apr 2018 02:39:14 GMT

Byron,

Thanks for this. '

That wasn't quite what I meant, though. I want Event to be the x-axis for both panes. I want the left pane to show Event %s for all users, and the right pane to show event %s for one user (let's say user A).

I'll be generating a new graph for each user…

John

Re: Graph builder overlay question

stephen_pearson — Mon, 16 Apr 2018 07:10:19 GMT

I'm not what you are asking is possible without adding the combined user Event summary data as new 'user'. That way you can use a local filter on the user in question plus the 'all users' results. Putting 'user' in the wrap or group X role should then allow you to produce the graph you desire.

Re: Graph builder overlay question

Byron_JMP — Mon, 16 Apr 2018 12:50:02 GMT

Two ways to do that, both methods use two separate GB frames and the Combine Windows feature.

1. Left frame is filtered by user with a local data filter

2. Left frame, :User is in the Wrap role, then only display one user at a time and use the arrow buttons to "Tab" between users.

Re: Graph builder overlay question

john_madden — Mon, 16 Apr 2018 13:58:25 GMT

Byron & Stephen,

Byron, thanks much, that's exactly what I wanted.

Stephen, I think you are right that it's not possible to do in a single graph builder frame, because you can't apply filters or column switcher differentially to the two panes. I struggled with trying to figure out a way to reconfigure the table, and like you I gave up.

Byron, the idea of using Combine Windows solves this problem.

Thanks to you both!!!!

John