When using the Run feature in On-Demand tables, it is necessary to load your project from the drop down menu. Once your project is loaded, you can choose a <study>.qpx OR definitions file and choose which data file to report on: Live or Test data, or an assembled suspend TR file. In order to produce a basic table, you need to define a minimum of one row. You will receive a javascript error message prompting you to define row(s) if none are selected. If you do not define a column, the table will run using Total.

The On-Demand Run feature initially creates a temporary table in a popup window. This table will NOT be saved unless you click the “Save” button on the bottom of the On-Demand page after initially creating the table. Once you click the “Save” button, you will then be prompted to name your table as well as set security on it. Only saved tables can then be viewed through the View Option.

To define columns, click the column tab. A popup menu will appear allowing you to add columns to report on. You can add a single column, multiple columns or all columns at one time. To add a single column to the Columns to Use box, click on the variable you want to add and then click the down arrow. To add multiple columns to the Columns to Us” box, hold down the ctrl key, click the variables you want to add and then click the down arrow. To add ALL columns to the Columns to Use box, click the “Add All” button and then click the down arrow. After adding your columns, click the “Save Selections” button.

If you do not define a column, the table will run using “Total”.

To define rows, click the rows tab. A popup menu will appear allowing you to add rows to report on. You can add a single row, multiple rows or all rows at one time. To add a single row to the Rows to Use box, click on the variable you want to add and then click the down arrow. To add multiple rows to the Rows to Use box, hold down the ctrl key, click the variables you want to add and then click the down arrow. To add ALL rows to the Rows to Use box, click the “Add All” button and then click the down arrow. After adding your rows, click the “Save Selections” button.

You must choose at least one variable in the row to run the report. 

When creating your tables, you have the option to define a base. By default, tables are run without a base displaying true totals. Tables produced with bases will only reflect the criteria that fit into your base. To run your table with a base, choose the Base tab. A popup box will appear with a drop down menu. Choose Define a base from the drop down menu and define your base accordingly.

When creating your tables, you also have the option to define weights. By default, tables are run without any weights defined. A weighted table is one in which each case is multiplied by some appropriate factor so that it carries a higher or lower weight in the sample. This is usually done when you want the distribution in the tables across some demographic group to reflect the universal distribution rather than your sample distribution.

To add weights to your table, choose the Weights tab. A popup box will appear with a drop down menu. Choose Define a weight from the drop down menu and define your weight accordingly.

By default, frequencies are turned on when running tables. To change frequency options, click the Table Options tab and then click Frequencies. A popup box will appear with various settings. When using frequencies, the default number of decimal places used is zero. Typically, the number of decimal places is only set if creating a table with a means. You can suppress frequencies that are less than “X” where X is defined as a real number. This is usually done for larger tables where you either want to suppress rows with no one in them or only want to display results for categories that have a significant amount of data in them. The default format for frequencies is a whole number without commas or dollar signs. This option can be changed to allow commas and dollar signs (designed for tables with money references). To shut frequencies off altogether, simply click the radio button with the keyword off. After specifying your frequency options, click the “Save Selections” button.

Frequency Options Include:

By default, On-Demand tables will print with the vertical percentages. To change percentage options, click the Table Options tab and then click Percentages. A popup box will appear with various settings. When using percentages, the default number of decimal places is 1. Most people keep this setting at either 0 or 1. If you have a large number of responses, it may benefit you to set the number of decimal places to 2 to see exact decimal percentages.

Other percentage options include vertical, horizontal and cumulative percentaging. Vertical percentaging is set by default. This provides percentaging off of the total for each banner point. The percentage for each category will be calculated off of the total. Frequencies can be suppressed if they are less than “X” where X is defined as a whole number. This is usually done for larger tables where you only want to display results for categories that have a significant amount of data in them. Horizontal percentaging provides percentaging off of the stub total for each banner point. The percentage for each category will be calculated off of the total row in the stub. Both vertical and horizontal percentaging can be based on Total or Any Response. If your table does not have any NO Answers, then the table produced will have the same outcome regardless of which option you choose. Cumulative percentaging will provide running totals of each of the vertical percents as you go down the table. This will print a cumulative percentage under the vertical percentage.

When printing percentages, you have the option to suppress the (%) sign. By default, small percentages round down to zero. By choosing the option to replace percentages rounded to 0 with an “*” and a footnote, it will replace the 0 percentages with an “*”. You also have the option to show frequencies only for the summary freq (Total, No Answer, Any Response) and show only percentages for the body of the table.

When designing your tables, you can choose any of the above options to build the table that fits your clients needs. To shut percentages off altogether, simply click the radio button with the keyword off. After specifying your percentage options, click the “Save Selections” button.

Percentage Options Include:

By default Statistical Testing is turned off. You can easily apply Statistical Testing to your On-Demand tables by choosing the on Option. Such tests include: All Possible Pairs, Anova Scan, Fisher and Neuman-Keuls. All tests can have up to 2 confidence levels applied. A footnote is created by default.

The All Possible Pairs Test (APP) is the default. When more than two columns are tested at a time, the APP test will act as though each pair in the set of columns is being tested individually. For instance, the same set of tests would be performed whether your STATISTICS statement was specified as ABC or AB,AC,BC. In general, out of all the tests, the APP test is the most likely to mark cells as significantly different.

The Newman-Keuls procedure (N-K) is in general not as likely to mark a test as significant as the APP test. This is because it uses the additional information supplied by all the columns in the test to produce a more reliable result. When testing more than two columns at a time, the N-K procedure assumes the items are alike and uses this additional information in its calculations.

The ANOVA-Scan and Fisher tests are similar in that both first perform an ANOVA (analysis of variance) on the set of columns, and then only test the individual columns if the ANOVA shows significance. The difference between the two is that the Fisher test, like Newman-Keuls, takes into account that multiple columns are being tested and therefore requires a larger t value to show significance. In general, these two tests are less likely than the APP test is to mark items as significant.

The confidence level can be set to any of the following: .80, .90, .95, .99, and APPROXIMATELY .nn (where nn is any value). The default significance level is 95%.

After specifying your Statistical Testing options, click the “Save Selections” button.

Statistical Options Include:

Other available options include: ranking, rank order (ascending or descending order), applying statistical decimals to your Mean, Standard Deviation, and Standard Error Values, specifying which summary columns to print for each banner as well as which summary rows to print; i.e. (Total, No Answer, Any Response). You can also specify which character you want to print for ZERO, MISSING and EMPTY CELLS. You can choose between a zero, a question mark, a dash or even specify your own specific characters.

After specifying your options, click the “Save Selections” button.

To specify a title for your On-Demand Tables, choose the Formatting Options tab and then click on Html Title. After specifying the Html Title, click the “Save Selections” button. The title will appear at the top of your tables. If you do not specify a title, the default title will display as Studycode Study.

Once you’ve specified the above options, you are now ready to run your table. To process your table, click the “Run” button on the bottom of the screen. Your temporary On-Demand table will be created and will appear in a popup in a separate window. Make sure you have Allow Popups turned on so you can access the table. This temporary table will automatically be named using your first and last name of your Console login.

Once the table is processed and it has successfully appeared in the popup window, you have the option to Save it and view it later. To save the temporary table, click the “Save” button next to the “Run” button on the button of the On-Demand options screen.

A pop up box will appear where you can specify the table file name and the table display name (which can be different from the file name). You can also choose a previously saved file from the drop down menu. The table generated will automatically be named as: studycode_loginname and will have “_odtables” appended to it. After choosing your file names, you can set security on these reports by clicking the Set Security check box (optional). When finished, click the “Submit” button. The file will now be listed under the View Option in On-Demand Tables. If you do not set security, the file can be accessed by anyone who has access to View for that particular study.

If you chose the Set Security option when saving your table in the above step, a popup box will appear allowing you to specify which users can have access to that table. A listing of Available Users will appear on the left and a listing of Assigned Users will appear on the right. Use the arrow buttons to move the users between the two boxes. To assign multiple users at once, hold down the ctrl or shift key as you highlight each user. For non-Survox Console users, choose a username and password. This is often used for clients that do not have Console access. Simply provide the table link with their username and password. After setting security options, click the “Submit” button. Once the table is finished processing, the link will be added to the the list of files in View. You can then click View under On-Demand Tables on the panel on the left side of the screen to view a listing of saved tables. In the example below, the assigned users on the right will have access to this report. In addition, the non-Survox Console user John Smith will also have access to the report. His user name is John and his password is Smith.

Some questionnaire syntax may not translate properly to the .ban file for On-Demand tables therefore resulting in errors. Below are some tips to avoid possible errors:

• Add the keyword MENTOR to the end of the ~PREPARE COMPILE line so the proper files are created for running tables
• Add brackets and a $ to any !IF condition references. For example, if you have !if intvID=“dbug”, change it to !if [intvID$]=“dbug”
• If you have any response codes with special characters; i.e. ??, ^^ or ==, you need to add (-mentor) before that response code.

Example:

    ~prepare compile mentor

    [bank]

    {intvID:
    !spc,5,1,4}

    {!if [intvID$]="dbug"
    !goto finish}

    {status:
    Hello my name is....

    !fld
    01 No Answer
    02 Busy
    03 Callback
    (-mentor)^^ Hit Return to continue}