Assigning Data to Roles

You can subset the data in the input data set by applying an SQL WHERE clause. In the Where string box, enter your valid SQL syntax. Operands that are character strings must be enclosed in single or double quotation marks. To view this WHERE clause with the resulting graph, select the Include as footnote check box.

To run the Bar-Line Chart task, you must assign a column to the Category variable, Bar response variable, and Line response variable roles.

Option Name	Description
Roles
Category variable	specifies the variable that classifies the observations into distinct subsets.
Bar response variable	specifies a numeric response variable for the bar chart.
Line response variable	specifies a numeric response variable for the line plot.
Group variable	specifies a variable that is used to group the data.
URL variable	specifies a character variable that contains URLs for web pages to be displayed when parts of the plot are selected within an HTML page.
Statistics
Mean	calculates the mean of the response variables.
Sum	calculates the sum of the response variables.