Cell-Based Weighting

Cell-based weighting in QuestionPro BI helps you adjust survey data so specific respondent groups are represented according to your desired target proportions. This is useful when you need dashboard results to reflect a defined distribution across selected survey questions, such as demographic or segment-based cells.

With a cell-based weighting scheme, you can choose a survey data source, select the questions that define the cells, enter target proportions, and then apply the completed scheme to dashboards or individual widgets. You can also reopen the scheme later to modify questions or update target proportions as analysis needs change.

Watch this video for a quick overview of Cell-Based Weighting in QuestionPro BI:

• From the left navigation panel, open Weightings in QuestionPro BI to access the workspace where weighting schemes are created and managed.


• Click New weight scheme to begin setting up a new weighting configuration for BI analysis.


• Choose Cell based weighting so the scheme can adjust results based on target proportions for selected question combinations.


• Select the survey data source that contains the responses you want to weight. This determines which questions and response cells are available for the scheme.


• Select the questions that should define the weighting cells. These questions create the response combinations that receive target proportions.


• Click Next after confirming that the selected questions define the required cells.


• Use the optional criteria step only if the scheme should be limited to specific response instances. If no extra filter is required, leave it unchanged and click Next.


• Enter a clear scheme name so the weighting setup can be identified later when it is applied to dashboards or widgets.


• Enter the target proportion for each cell. These values define the distribution that the weighted analysis should follow.


• Review the target proportions and make sure the total adds up to 200; the scheme must meet this total before it can be saved.


• Click Save to create the cell-based weighting scheme with the configured cells and target proportions.


• Monitor the progress panel in the bottom-right corner until the scheme creation process finishes.

• Open the created weighting scheme from the Weightings list when you need to review or adjust its configuration.


• Click Modify questions if the scheme should use a different set of questions to define its cells.


• Update the target proportions if the desired distribution changes after the scheme has been created.


• Click Update scheme to save the revised question selection or target proportions.

• Navigate to Dashboards to find the dashboard that contains the widget where the weighting scheme should be used.


• Open the dashboard so you can configure the widget-level settings.


• Open the settings panel of the widget in which you want to apply the weight scheme.


• In the widget settings panel, go to the Analytics tab and choose the widget-level weighting mode.


• Open the Weight schemes dropdown and select weighting scheme that should be applied to the widget analysis.

• Open the dashboard where the weighting scheme should be applied across the full dashboard analysis.


• Open the dashboard settings panel from the top-right settings icon.


• Select the Weightings tab to configure a dashboard-level weighting scheme.


• Open the dashboard-level weight scheme dropdown and select the desired weight scheme from the dropdown.


• Click Save to apply the selected weighting scheme to the dashboard-level analysis.