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:

2 Comments
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

image.png

 

Transformed column example

image.png

 

 

Script for the transformed column example:

Graph Builder(
	Size( 491, 454 ),
	Show Control Panel( 0 ),
	Variables(
		X( :Robbery ),
		Y( :Population ),
		Overlay(
			Transform Column(
				"Region, State",
				Character,
				Nominal,
				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.