eNPS survey report by department
Scores, distribution bars and changes for each department
- Template
- DOCX
- Export as
- PDF, DOCX, ODT, HTML, PNG +25 more
- Carbone
- 5.0+
Generate eNPS survey reports from your survey platform
HR and people analytics teams publish the results of each engagement survey by department, two to four times a year. Your survey platform or HR data warehouse sends the counts of each department to the Carbone API as JSON: employees invited, responses, and the number of promoters, passives and detractors on the eNPS question. The DOCX template computes the eNPS of each department, sorts the departments, and draws a native Word bar chart in each table row.
In this example, Quillmont Distribution, a fictional distributor of 1,254 employees, reports its fall 2026 survey: eNPS by department with the change since spring, the highest and lowest scoring statements, and a methodology note. eNPS follows the Net Promoter Score method on the question "How likely are you to recommend Quillmont as a place to work?", answered from 0 to 10: the percentage of promoters (9 or 10) minus the percentage of detractors (0 to 6). Like survey platforms, the template never shows the results of a group of fewer than 5 respondents.
In this example, you will:
- Compute the eNPS of each department from the answer counts
- Sort the departments by eNPS and hide the groups under 5 respondents
- Insert a native Word bar chart in each table row
- Print company totals and the change since the previous survey
How to build an eNPS report with a chart in each row
Follow these steps to compute the scores and add a bar chart to each row of a table with Carbone:
1. Compute the Scores at the Top of the Template
Insert the tags that print nothing in a paragraph that already holds text, here the line above the title, so they leave no empty line. The :set formatter stores the result of a computation in a new attribute of each department:
{d.departments[].promoters:sub(.detractors):div(.respondents):mul(100):round(0):set(.enps)}
{d.departments[].enps:sub(.enpsPrevious):set(.change)}
{d.departments[].enps:mul(-1):set(.rank)}- The first tag computes the eNPS: :sub subtracts the detractors from the promoters, :div divides by the responses, :mul converts the ratio into points and :round rounds it. Passives count in the responses, not in the score, so the eNPS ranges from −100 to +100.
- The second tag computes the change since the previous survey.
- The third tag stores the opposite of the eNPS, used in step 3 to sort the departments from the highest score to the lowest.
Then add up the company totals with :aggSum and store them in a new total object:
{d.departments[].invited:aggSum:set(d.total.invited)}
{d.departments[].respondents:aggSum:set(d.total.respondents)}
{d.departments[].promoters:aggSum:set(d.total.promoters)}
{d.departments[].passives:aggSum:set(d.total.passives)}
{d.departments[].detractors:aggSum:set(d.total.detractors)}
{d.total.promoters:sub(d.total.detractors):div(d.total.respondents):mul(100):round(0):set(d.total.enps)}The totals include every respondent, also those of the groups too small to be shown.
2. Show the Headline Figures
In the four tiles below the title, print the totals:
- the responses
{d.total.respondents:formatN(0)}and the response rate{d.total.respondents:div(d.total.invited):mul(100):round(0)}%; - the number of departments shown with :aggCount:
{d.departments[respondents > 4].name:aggCount} of {d.departments[].name:aggCount} departments reported; - the eNPS with its sign:
{d.total.enps:ifGT(0):show('+'):elseShow('')}{d.total.enps}.
The change since the previous survey takes three runs: a green one with {d.total.enps:sub(d.survey.previousEnps):ifGT(0):show('▲ '):elseShow('')}, a red one with {d.total.enps:sub(d.survey.previousEnps):ifLT(0):show('▼ '):elseShow('')}, then the value without its sign with :abs: {d.total.enps:sub(d.survey.previousEnps):abs}. :show and :elseShow print the arrow only when the condition is true.
3. Sort the Rows and Hide the Small Groups
Insert a table with a header row, a company row and two rows for the loop. In the first loop row, use the rank attribute instead of i to sort the departments:
{d.departments[rank, i].name}and{d.departments[rank, i].respondents};- the response rate
{d.departments[rank, i].respondents:div(.invited):mul(100):round(0)}%; - the eNPS
{d.departments[rank, i].enps:ifGT(0):show('+'):elseShow('')}{d.departments[rank, i].enps}; - the change
{d.departments[rank, i].change:abs}, after the two arrow tags of step 2.
In the second row, write {d.departments[rank+1, i+1, respondents > 4]}. The filter respondents > 4 applies to the whole loop and keeps the groups of 5 respondents or more, even when the JSON contains smaller groups. The second row does not appear in the generated report.
4. Add a Bar Chart in Each Row
In the distribution cell of the first loop row, insert a native chart of type 100% Stacked Bar. Right-click the chart, select Edit Data in Excel, and keep one category and three series, with these tags in row 2:
| | Detractors | Passives | Promoters |
|---|-----------------------------------------------------------------|---------------------------------------------------------------|----------------------------------------------------------------|
| | {d.departments[i].detractors:div(.respondents):mul(100):round(0)} | {d.departments[i].passives:div(.respondents):mul(100):round(0)} | {d.departments[i].promoters:div(.respondents):mul(100):round(0)} |You do not need to define the loop in the chart: Carbone uses the loop of the table row, in the sorted order, so each row gets a chart with the shares of its department.
Then make the chart a simple bar:
- Delete the chart title, the legend, the axes and the gridlines, and set the gap width to 20%.
- Color the series in muted red, light gray and green, and add data labels to the detractors and promoters with the number format
0"%". - Type the legend in the header cell, with colored ■ characters.
The company row holds the same chart, fed by the totals, for example {d.total.promoters:div(d.total.respondents):mul(100):round(0)}.
5. List the Highest and Lowest Scoring Statements
Below, a second table repeats the same structure for the statements rated on a 5-point agreement scale, with one loop on strengths and one on opportunities:
{d.strengths[i].item},{d.strengths[i].favorable}%and the change{d.strengths[i].favorable:sub(.favorablePrevious):abs}, after the two arrow tags;- a 100% stacked bar chart fed by
{d.strengths[i].unfavorable},{d.strengths[i].neutral}and{d.strengths[i].favorable}; {d.strengths[i+1]}in the next row to end the loop, then the same rows withopportunities.
6. Write the Methodology Note
State the confidentiality threshold, then list the departments it hides with :aggStr:
{d.departments[respondents < 5].name:aggCount:ifEQ(0):drop(p)}Not reported this wave: {d.departments[respondents < 5].name:aggStr(', ')}.The first tag removes the paragraph when no group falls below the threshold, so the note never prints an empty list.
Tip: long tags can wrap anywhere in a narrow cell, which makes them hard to read in the template. Add a space where you want the line to break, for example {d.departments[rank, i] .respondents:div(.invited) :mul(100):round(0)}. Carbone ignores these spaces when generating the document.
Save the DOCX template, connect it to your survey data, and let Carbone build the report of each survey wave.
Related Examples
Trusted by 800+ paid customers in 40+ countries














