Blog · Board and management reporting
An employee satisfaction dashboard compares aggregate survey results and participation across reporting periods. Follow a worked example with question-level denominators, score distributions, confidentiality checks, and a change in one scoring input.
An employee satisfaction dashboard compares aggregate survey scores and response rates by period and sufficiently large group. Put eligible invitations, submitted surveys, and valid answers beside every score so managers can distinguish a change in sentiment from a change in participation.
Use a summary supplied by the survey owner, with a row for each reporting period, approved group, and question. The file needs eligible invitations, submitted surveys, and counts for each answer choice. Leave employee names, identifiers, individual response histories, and unreviewed comments out of this reporting file.
Define participation before opening the results. In this example, a submitted survey is one unique eligible employee's submission received by the deadline. The survey administrator resolves duplicate submissions before producing the aggregate file. Each employee belongs to one reporting group in each period, using the same assignment rule.
The general survey dashboard covers questionnaire methods and response mix in more detail. Here the operating question is narrower: which large employee groups need follow-up, and can the survey owner substantiate the reported change?
An illustrative US business services company invites all eligible employees in Operations and Commercial. Both quarterly surveys use the same question: how satisfied are you overall with working here? Responses run from 1, very dissatisfied, to 5, very satisfied; scores 4 and 5 are favorable.
These are aggregate counts from the approved export. Q2 covers April through June 2026; Q3 covers July through September 2026. Submitted surveys may skip this question.
| Period | Group | Eligible invitations | Submitted surveys | Score 1 | Score 2 | Score 3 | Score 4 | Score 5 |
|---|---|---|---|---|---|---|---|---|
| Q2 | Operations | 180 | 108 | 10 | 14 | 20 | 34 | 22 |
| Q2 | Commercial | 120 | 96 | 4 | 8 | 10 | 34 | 34 |
| Q3 | Operations | 180 | 108 | 8 | 12 | 20 | 36 | 24 |
| Q3 | Commercial | 120 | 96 | 3 | 6 | 9 | 36 | 36 |
Valid answers are the sum of the score counts. For Q3 Operations, that is 8 + 12 + 20 + 36 + 24 = 100. Its skipped-question count is 108 submitted surveys minus 100 valid answers = 8. Q3 Commercial has 90 valid answers and 96 − 90 = 6 skipped answers.
Response rate = Submitted surveys / Eligible invitations
Favorable share = Answers scored 4 or 5 / Valid answers
Mean score = Sum of each score × Its answer count / Valid answers
The OPM survey technical report similarly combines positive response choices and excludes unanswered items from item-level percentages. That supports the distinction between survey participation and question-level scoring; its federal survey results are not a benchmark for this company.
Q3 Operations contributes 1 × 8 + 2 × 12 + 3 × 20 + 4 × 36 + 5 × 24 = 356 score points. Commercial contributes 1 × 3 + 2 × 6 + 3 × 9 + 4 × 36 + 5 × 36 = 366 points.
| Period | Group | Valid answers | Score points | Favorable answers | Response rate | Mean score | Favorable share |
|---|---|---|---|---|---|---|---|
| Q2 | Operations | 100 | 344 | 56 | 60.0% | 3.44 | 56.0% |
| Q2 | Commercial | 90 | 356 | 68 | 80.0% | 3.96 | 75.6% |
| Q2 | Total | 190 | 700 | 124 | 68.0% | 3.68 | 65.3% |
| Q3 | Operations | 100 | 356 | 60 | 60.0% | 3.56 | 60.0% |
| Q3 | Commercial | 90 | 366 | 72 | 80.0% | 4.07 | 80.0% |
| Q3 | Total | 190 | 722 | 132 | 68.0% | 3.80 | 69.5% |
Calculate from unrounded inputs, displaying means to two decimal places and percentages to one. Q2 score points are 10 + 28 + 60 + 136 + 110 = 344 for Operations, and 4 + 16 + 30 + 136 + 170 = 356 for Commercial.
Each period has 180 + 120 = 300 eligible invitations and 108 + 96 = 204 submissions. Therefore participation is 204 / 300 = 68.0%. Q3 favorable share is (60 + 72) / (100 + 90) = 69.5%; its mean is (356 + 366) / 190 = 3.80.
The checks are straightforward: valid answers plus skips must equal submitted surveys, and mutually exclusive groups must sum to the period total. The company mean divides total score points by total valid answers. Averaging the displayed group means gives each group equal weight and is the wrong aggregation here.
The company mean increased by (722 − 700) / 190 = 0.12 score points after rounding. Favorable share increased by (132 − 124) / 190 × 100 = 4.2 percentage points. Both groups improved, while invitations and participation counts stayed unchanged.
That is a descriptive improvement among respondents. It does not establish that the same employees answered both times or that a management initiative caused the movement. The Census Bureau explains that nonresponse can introduce bias when respondents and nonrespondents differ. Its household-survey discussion illustrates the risk rather than prescribing an employee survey method.
The HR survey owner should review the participation gap between Operations and Commercial before setting a companywide action. Operations leaders can then investigate specific issues through an appropriate confidential follow-up process. An employee turnover dashboard supplies a separate workforce outcome; an employee performance dashboard answers a different management question and should not be used to identify survey respondents.
Hold Q3 invitations, submissions, and valid-answer counts fixed. In a sensitivity scenario, six Operations answers move from score 3 to score 4. This changes the assumed answer distribution, not the observed survey result.
| Measure | Observed Q3 | Sensitivity scenario | Calculation |
|---|---|---|---|
| Operations score 3 count | 20 | 14 | 20 − 6 |
| Operations score 4 count | 36 | 42 | 36 + 6 |
| Operations score points | 356 | 362 | 356 + 6 × (4 − 3) |
| Company favorable answers | 132 | 138 | 132 + 6 |
| Company favorable share | 69.5% | 72.6% | 138 / 190 |
| Company mean score | 3.80 | 3.83 | (362 + 366) / 190 |
The scenario shows why the distribution matters. Moving neutral answers to satisfied increases both measures while leaving participation unchanged. It is a sensitivity check, not a prediction that a particular action will produce those answers.
Bring an approved aggregate survey file with eligible invitations, submitted surveys, and answer counts by period and sufficiently large group. Covirage maps the columns, its tools compute and check the figures, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account in about a minute, then set up your business and bring a sample of your own data.
See self-service analytics for the supporting approach to business reporting.
Include the survey period, eligible invitations, submitted surveys, valid answers, favorable share, and score distribution. Show results only for groups that meet your confidentiality policy, and put the question wording and scale beside the measures so managers can compare periods fairly.
Broader participation gives more employees a voice, but a higher rate does not establish that results represent everyone. Compare participation across sufficiently large groups and check whether the respondent mix changed before treating an overall score increase as improved satisfaction.
No. Keep skipped and inapplicable answers outside the valid-answer denominator unless the questionnaire explicitly defines another method. Show the excluded count separately. A submitted survey can count toward participation even when it has no valid answer to a particular satisfaction question.