Our World Statistics Day conversations have been a great reminder of how much statistics can inform our lives. Do you have an example of how statistics has made a difference in your life? Share your story with the Community!
Choose Language Hide Translation Bar
0 Kudos

Graph Builder - Overlay by multiple columns

I would like to have Graph Builder be able to Overlay by several variables in the same way that x, y or color drop-zones can take several variables. This would allow overlay to be selected/deselected from the "Variables" group under each graph type and create much more complex and rich visualizations.

Tracking Number:

Defect ID:

Super User

Currently,  there are methods that might meet your needs today:

  • Add a column switcher to your report that switches out the Overlay Variables,
  • Create a new Column, or transform a column to be a concatenation, and
  • for an additional level of control especially for nested overlay variables add a Local Data Filter

Row Switcher example



Transformed column example




Script for the transformed column example:

Graph Builder(
	Size( 491, 454 ),
	Show Control Panel( 0 ),
		X( :Robbery ),
		Y( :Population ),
			Transform Column(
				"Region, State",
				Formula( :Region || ", " || :State )
	Elements( Points( X, Y, Legend( 1 ) ), Smoother( X, Y, Legend( 2 ) ) ),
	Local Data Filter(
		Add Filter(
			columns( :Region ),
			Where( :Region == "Midwest" ),
			Display( :Region, Size( 160, 120 ), List Display )


Level III

Thanks @gzmorgan0 , indeed, it can be achieved in several ways but I consider those "workarounds" ... I am more looking for the feature to have multiple fields in overlay, the same way that it was implemented for Color some time ago.