If you insert a reference to the base value of a saved table in your report, you will automatically get the filtered base when you filter the report.<\/p>\n
Background<\/h3>\n
Cell references are a means of inserting automatically updated data in a report (or in the notes for an analysis). A cell reference is the position in the specified table of where the data is shown.<\/p>\n
The cell referred to can be:<\/p>\n
- \n
- A row label (describe by tablename<\/em> R<\/strong>N<\/em> label<\/strong> e.g. AN1 R1 label<\/li>\n
- A column label (describe by tablename<\/em> C<\/strong>N<\/em> label<\/strong> e.g AN1 C1 label)<\/li>\n
- A data cell described by its row and column number (describe by tablename<\/em> R<\/strong>N<\/em>C<\/strong>N e.g AN1 R1C1<\/em>)<\/li>\n
- A statistic value described by its row and statistic number (where its statistic number is its position in the list of statistics, S1 being the top, given by tablename<\/em> R<\/strong>N<\/em>S<\/strong>N<\/em> e.g. AN1 R1S1)<\/li>\n<\/ul>\n
where N<\/em> is replaced by the row or column number.<\/p>\n
Once you have inserted the cell reference into the report, any filters applied to the whole report are applied to the table that the referenced cell is part of.<\/p>\n
You can use any analysis as the basis for the reference. For example, if you wish to insert a reference to data in a chart, view the chart as a table to find out what the cell reference is, and then redisplay it as a chart.<\/p>\n
Summary of steps<\/h3>\n
Step 1: Creating the analysis containing the cell to reference<\/a>
\nStep 2: Inserting the reference in your report<\/a>
\nStep 3: Applying the filter<\/a>
\n<\/a><\/p>\nStep 1: Creating the analysis containing the cell to reference<\/h4>\n
You can use any analysis to provide the filtered base. For this worksheet, you will create a simple table to provide the cell reference.<\/p>\n
- \n
- \n
- \n
- Click
![\"table\"](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2014\/06\/table.png\")
on the toolbar to create a table.<\/li>\n - The Analysis Definition<\/strong> dialog will open.<\/li>\n
- Enter a question that all respondents answer in the analysis field (the example uses Q1<\/strong>).<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n
If you do not use a Must Answer question, ensure all respondents are included in the Base value by selecting the Base\/Labels<\/strong> tab and setting the Errors<\/strong>, Not Asked<\/strong> and No Reply<\/strong> fields to Hide<\/strong> instead of Exclude<\/strong>.<\/em><\/span><\/p>\n
The example shows the Available<\/strong> field set to No<\/strong>. If you are only using an analysis to provide a cell reference, you would not want it to be available to view on Snap WebHost.<\/p>\n
\n![\"Results](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2014\/06\/def_not_av_tab.png\")
<\/p>\n<\/div>\n- \n
- Click [OK]<\/strong> to create the table then click
![\"Save](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2013\/09\/save.png\")
\u00a0to save it.\n\n![\"Smart](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2014\/06\/base_ref_hl.png\")
<\/p>\n<\/div>\n<\/li>\n- The Base<\/strong> value is displayed in the first column.<\/li>\n
- Click on the base value. Right click and select ‘Copy Cell Reference’. In this example, the reference will be the table name, followed by a space and R0C1 (row 0, column 1).
\n(You can click in other cells to see their references.)<\/li>\n<\/ol>\n<\/a><\/p>\n
Step 2: Inserting the reference in your report<\/h4>\n
- \n
- Click
![\"Batches](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2014\/05\/batch1.png\")
\u00a0on the Snap toolbar to open the Reports<\/strong> window.<\/li>\n- Select the Summary<\/strong> report and click
![\"Clone](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2014\/05\/clone.png\")
\u00a0to make a copy of it. This will ensure that you can go back to the original if you make any mistakes.<\/li>\n- Close the copy and open the Summary<\/strong> report.\n
![\"REP:](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2014\/06\/rep_sum_inst.png\")
<\/div>\n<\/li>\n- Double-click the Information<\/strong> instruction to open it. The default text is:\n
<\/div>\n{Title}<\/strong><\/p>\n
<\/div>\nThis report was generated on {date}, giving the results for \u00a0{cases} respondents.<\/strong><\/p>\n
<\/div>\nA filter of ‘{filter}’ has been applied to the data.<\/strong><\/p>\n
<\/div>\n<\/li>\n- Change the last sentence to read The report has been filtered to show the responses for ‘{filter}’ ( cases)<\/strong>.<\/li>\n
- Place the cursor after the open bracket, click the [Insert]<\/strong> button and select Cell Values Field…<\/strong> from the options.<\/li>\n
- The New Cell Values<\/strong> dialog opens. Enter the Cell Reference<\/strong> for the Base<\/strong> cell in your table. Remember to leave a space between the table name and the cell position (e.g. AN15 R0C1<\/strong>).<\/li>\n
- Click [OK]<\/strong> to insert the field.\n
![\"Printer](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2014\/06\/inf_cell_ref_basev2.gif\")
<\/div>\n<\/li>\n- Click [OK]<\/strong> to save your changes.<\/li>\n<\/ol>\n
<\/a><\/p>\n
Step 3: Applying the filter<\/h4>\n
- \n
- Add the filter to the Filter field at the top of the report window. For example, using the demographic question Q10. Are you male or female<\/strong>?
\n![\"Inserting](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2014\/05\/gender.png\")
\nEnter Q10=2<\/strong> in the Filter field to create a report using only the data from women.<\/p>\n\n![\"REP:](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2014\/05\/sum_rep_fil_hl.png\")
<\/p>\n<\/div>\n<\/li>\n- Click the
![\"Play\/run](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2014\/05\/12258.png\")
\u00a0button on the report window toolbar to run the report.
\nThe data that you have referenced will be filtered, so that when you run the report, you will see the correct filtered base value.<\/p>\n<\/div>\nThis report was generated on 02\/06\/14. Giving the results for 204 respondents.<\/strong><\/p>\n
<\/div>\nA filter of ‘Gender=Female’ (59 cases) has been applied to the data.<\/strong><\/li>\n<\/ol>\n
If you are content with the new version of the report, delete the clone back-up.<\/p>\n
Conclusion<\/h3>\n
This worksheet has described how to use a reference to a table cell to insert a filtered base in your standard Summary Report<\/strong>.<\/p>\n
To find out more about using references to cells, see the help topic: Inserting the content of a table cell<\/a>.<\/p>\n
For instructions about inserting references to ordered tables, see the worksheet: Creating a smart report which includes automatic text<\/a> and the help topic: Inserting dynamic data from a ranked table to put highest and lowest values in your report<\/a>.<\/p>\n
For further information about the Summary Report, see the help topic: Changing the default reports supplied with Snap<\/a> and the worksheet: Adapting the automatic Summary Report<\/a> (WS:106).<\/p>\n
If there is a topic you would like a worksheet on, email to snapideas@snapsurveys.com<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
- Click the
- Select the Summary<\/strong> report and click
- The Base<\/strong> value is displayed in the first column.<\/li>\n
- Enter a question that all respondents answer in the analysis field (the example uses Q1<\/strong>).<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n
- Click
- A column label (describe by tablename<\/em> C<\/strong>N<\/em> label<\/strong> e.g AN1 C1 label)<\/li>\n