Define breakdown by query values

When you create an interactive report definition, you define a query that will be run when the report is run. The report is run against the cases found by the query. You can set up a breakdown variable to use user-specified query values as the breakdown details. For example, you can define a report that uses user-specified values for Outcome as breakdown values.

Note: You cannot define breakdown by query values for numeric or date variables.

1.         In the left navigation pane, hover on the Data Analysis icon (), then click Report Definitions.

2.         On the Report Definitions page, accept the case series shown or click Browse to the right of Case Series to display the Select Case Series page and select a case series.

3.         Click a Report Definition's Row Action menu (), then click Edit.

4.         On the Edit Report Columns page, next to Breakdown Details, click Select.

5.         In the Breakdown Details dialog box, click Query Values.

6.         To include a column or row to represent null (missing) values for the variable, check Include a category for NULL values.

7.         To include a column or row in the report to represent all the values provided to the query, including null values, check Include a category for ALL selected values. For reports that display percentages, the report must include a row or column for All.

Note: If a case is counted in multiple columns, a count in the All column is not necessarily the same as the total of counts in other columns of the report.

8.         To include a column or row for values that are not represented by any other columns, check Include a category for all unselected values.

9.         Click OK.

Make sure that the query for the report definition includes the breakdown variable.