x

Data Sources and Filters

Home > Reporting > Reporting Beta > Data Sources and Filters
Reporting

Step-By-Step

Add and modify sources of data for your report. Filter and weigh the data from these sources. If no data sources are being used, a prompt will appear to Choose a Survey.

Filtering a Data Source
Filter a data source to exclude certain responses from your report. Filters can be set based upon question responses, a date range, completion status, and other criteria. To create a filter:

  1. Click Add a Filter next to any of your data sources.

  2. Select which type of filter you would like to add:

    • Filter by Question Response: Show only respondents who gave answers that meet the criteria you specify.
    • Filter by Completion Status: Display All Responses, only Completed Responses, or only Partial Responses.
    • Filter by Date Range: Only display responses submitted within a specified date range.
    • Filter by Scoring: Display only responses that have a score within a specified range.
    • Filter by Embedded Data: Display only responses that have embedded data which meets the criteria you specify.
  3. Follow the prompts, entering the necessary information (question and answer choice, embedded data, date, etc.).

  4. Click the gray plus and minus buttons to add or remove additional lines of logic as needed.

  5. Click Apply the Filter.

Data Source Options


The following options can be used by clicking the black drop-down arrow at the right of a data source:

  • Generate Report: Create a new report based upon this data source.
  • Edit Time Series: Subdivide charts and graphs into time periods to view data trends.
  • Variable Weights: Weigh data to better reflect the target population.
  • Rename Data Source: Create an alternate label or name for your data source.
  • Choose Response Set: Select to pull data from a different response set within the data source. This feature is being phased out with the Reporting Beta.
  • Set Data Source Group: Group data sources together. You can then collapse data sources using the plus button to the left of the grouped data sources.
  • Collapsed: Collapse the space used for the data source.
  • Remove Data Source: Remove the data source from the report. You are given the option to delete items and pages tied to this data source.
  • Add a New Data Source: Add a new data source to the report. After adding a new data source with this method, the Generate Report option is typically used.
Time Series
Subdivide tables and graphs into time periods to view data trends. To set up a time series:

  1. Click the black drop-down arrow at the right of a data source.
  2. Select Edit Time Series.
  3. Specify how you want to set up the time series:

    • Last: Subdivide tables and graphs to show the specified number of previous days, weeks, months, quarters, or years. Choose any of these additional options as needed:
      • Reversed: Show more recent data first in tables and graphs instead of last.
      • Include the current interval: Specify whether you want to include the current time period in tables and graphs, or wait until the interval is over before it is included.
      • Use custom descriptions: Create a custom description for each time interval.
    • Date Range: Specify a date range and choose to subdivide by days, weeks, months, quarters, or years. Select Use custom descriptions to enter custom descriptions for each interval.
    • Click Save.
Variable Weights
Weigh your data to reflect real-world population characteristics. For example, if your target population has 50% males and 50% females, but your responses include 30% males and 70% females, variable weighting allows you to weigh male’s responses more heavily in the calculation of statistics. To set up variable weighting:

  1. Click the black drop-down arrow at the right of a data source.
  2. Select Variable Weights.
  3. Choose a Weight Type:

    • Weight: Specify a multiplier to be used for certain responses. For example, if you enter ‘2’ for Male, Male responses will each be counted twice in the report.
    • Target Percent: Specify a target percent for specific answer choices. For example, if you enter ‘50%’ for Male, Male responses will be multiplied by a constant value so that they represent exactly 50% of the results.
    • Target Count: Specify a target count to be used for certain responses. For example, if you enter ‘100’ for Male, Male responses will be multiplied by a constant value so that they represent exactly 100 of the responses.
  4. Click the Select Question button and choose the question and answer choice.
  5. In the numeric field on the left, enter the value you would like to use.
  6. Use the blue plus button or click Add a Variable Weight Logic Set to weigh additional answer choices, if desired.
  7. Click Save.