This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
help:report_tables [2012/11/02 11:46] 127.0.0.1 external edit |
help:report_tables [2022/04/17 16:46] (current) 151.210.131.93 old revision restored (2015/09/17 06:12) |
||
---|---|---|---|
Line 3: | Line 3: | ||
====== Making Report Tables ====== | ====== Making Report Tables ====== | ||
- | |||
- | ===== Updated Versions of SOFA ===== | ||
- | |||
- | This documentation was written for older versions of SOFA but is still basically correct. The "Run" button is now called "Show Results"; and Row Stats Report Tables have now swapped rows and cols so that the stats (mean, median, std dev etc) show across rows and are grouped by columns. Updating all the screen shots is on the to-do list ;-) | ||
- | |||
===== Making a Simple Crosstab Table ===== | ===== Making a Simple Crosstab Table ===== | ||
Line 23: | Line 18: | ||
Under the "Columns" label click on "Add" and add Country. | Under the "Columns" label click on "Add" and add Country. | ||
- | In the demonstration pane below you will see a rough illustration of what the table will look like. If you want to see the actual table, click on "Run". | + | In the demonstration pane below you will either see the table or a rough illustration of what the table will look like (if there is so much data that displaying the actual results may take a while). |
{{:help:crosstab_output.jpg|}} | {{:help:crosstab_output.jpg|}} | ||
- | If "Add to report" is ticked, the output will also be saved to the end of the output file specified at the bottom of the form. | + | If the "Also add to report" button is pressed the output will also be saved to the end of the output file specified to the right of the button. |
===== Extra Configuration of Report Table ===== | ===== Extra Configuration of Report Table ===== | ||
Line 38: | Line 33: | ||
- Tick "Total" under the "Misc" heading | - Tick "Total" under the "Misc" heading | ||
- Tick "Column %" and "Row %" under the "measures" heading | - Tick "Column %" and "Row %" under the "measures" heading | ||
- | - Click on "OK" to see changes in demonstration table. NB to see actual results, click on "Run". | + | - Click on "OK" to see changes in the table. |
{{:help:impact_of_config_changes.jpg|}} | {{:help:impact_of_config_changes.jpg|}} | ||
- | If you click "Run" with "Add to report" ticked, you can view the result by clicking on the "View" button. This will open your default web browser so you can see the output. | + | If you clicked "Also add to report" (or "Show Results" with "Also add to report" ticked if demonstration results displayed only) you can view the result by clicking on the "View" button. This will open your default web browser so you can see the output of the entire report. |
{{:help:output_saved_to_report.jpg|}} | {{:help:output_saved_to_report.jpg|}} | ||
Line 70: | Line 65: | ||
- Under the "Cols" label click on the "Config" button. | - Under the "Cols" label click on the "Config" button. | ||
- | - Select the measures you wish to report on. Mean is preselected by default. | + | - Select the measures you wish to report on. Hold down Ctrl while making selections to select multiple. Mean is preselected by default. |
- Click "OK". | - Click "OK". | ||
Optionally, you can add a row variable e.g. "Age Group". Row variables for "Row Stats" report tables can have totals. | Optionally, you can add a row variable e.g. "Age Group". Row variables for "Row Stats" report tables can have totals. | ||
- | |||
- | NB Click on the "Run" button to produce the output. Also note that all the data in the "demo_tbl" is fictitious. | ||
{{:help:row_stats_output.jpg|}} | {{:help:row_stats_output.jpg|}} |