 |
 |
 |
|
   |
||||||||
|
|
|||||||
|
Results Page Help
The results page contains several sections, providing a table with the results of your query along with additional information about the query and options to modify the look of the results and export them to a file. Please see these topics for more information:Results Table
Export Results
Results Information
Notes
Citation
Query Criteria
Table Options
Printing Tips
Results Table
The results table is initially shown in one of two formats. Value labels are typically displayed once for each unique value. But if this causes a single label to have to cover many rows, making the table hard to read, the table is drawn with every label written on every row. The initial display can be changed by using the Table Options form.
Export Results
The data contained in the results table can be exported to a file by pressing the button at the top of the table. Columns are separated by tabs, a format that allows this file to be imported into a wide variety of programs, such as Excel and Epi-Info. More information on how to import this file into other applications can be found here.
Results Information
Each page that holds the results of a data query, this page plus the Map and Chart pages, contains a set of standard sections that contain information about the results and the query used to produce them. These sections are:Notes
Citation
Query CriteriaNotes
This section provides information about the request and results, including a suggested citation, a link to the help file for the request, and the date and time the query was processed. There can also be an Caveats heading. If present, this provides information about the request that is needed in order to correctly interpret the results.For example, suppose a mortality request covers a set of counties spanning several years, and is grouped by county. Counties go in and out of existence over time. If one of the counties in this request was not in existence for all the years of the request, the number of deaths reported would be relatively less compared to the other counties. In a case like this the Caveats heading would contain a note explaining that this was the case.
Citation
This section contains the citation that should be used in relation to the query.Query Criteria
This section contains a list of all the variable values, and other parameters that went into the request.
Table Options
You can change how your results are displayed by selecting the desired options and pressing the button. If an option is not available for a particular set of results it is disabled. The available options are:
Title Enter any desired title to be included with your results. Show Totals If checked totals and sub-totals will appear in the results table. Show Zeros If checked rows containing zero counts will appear in the results table. If unchecked, zero count rows are suppressed. Precision Determines the number of decimal places to show for measures that aren't whole numbers, such as rates. Measures that are whole numbers are unaffected. If a dataset contains only whole number measures this option is disabled. Show All Labels This causes every label in the table to be written on every line. This can make some tables more readable, especially ones with several by-variables and many variable values involved. It can also make these tables easier to print, see Printing Tips for more information.
Printing Tips for Results, Map and Chart pages
These pages contain internal formatting to control printing that eliminates unnecessary items from the printed results like headers and footers. Simply print the page from the browser by clicking the printer icon or choosing File / Print from the browser's menu bar. You can also check to see how the pages will look before printing by selecting the File / Print Preview menu pick.The map and chart pages are formatted so that each map or chart starts on a new page. To change this simply uncheck the option called "New Page Each Map/Chart".
The table of data on the results page is also formatted so that the column headers are repeated at the start of each page.
A label on the results data table that spans too many rows can cause printing problems. To rectify this, check the "Show All Labels" option from the Table Options form and click the button. This will cause the table to be redrawn with labels repeated on every row.
