I have sets of data collected using ExecuteSQLs comparing success rate in various categories.

Ie.

(1) Number of times A attempted, (2) Number of times A successful

(1) Number of times B attempted, (2) Number of times B successful

(1) Number of times C attempted, (2) Number of times D successful

Is there a way I can create a Column chart in FMP that shows each attempt-success number pairing in different colors all within the same chart? Can I utilize List ( )?

Then

List ( calculationfield 1 ; Calculationfield 2 ; and so forth... )

can be specified as the Y series for your graph.

List ( "Label for bar 1" ; "Label for bar 2" ; and so forth... )

Can be used as the calculation for the x-series.