You can create an NPS report in Databox using data from Google Sheets or any other custom data source like SQL or Custom API.
Create a count of NPS Scores by Score
Open Metric Builder and select Google Sheets as the data source.
For the value field, select the column/row in your spreadsheet where you store the NPS scores submitted by users.
Set the Dimension to the same column that you selected for the value.
Optionally, if you have a date column/row you can select it.
Set the Aggregation Function to "Count".
Name the custom metric and save it. This will now give you a count for each score.
Calculate total count of Promoters and Detractors
Open Data Calculations.
Promoters: Create a custom metric where you sum together scores 9 and 10 and name it "Promoters". Save the metric.
Detractors: Create another metric where you sum together all scores from 1 to 8 (including 8) and name it "Detractors". Save the metric.
Calculate the Promoter and Detractor percentage
Open Data Calculations.
Promoters %: Create a custom metric where you divide Promoters by Promoters + Detractors. Set the format to Percentage.
Detractors %: Create a custom metric where you divide Detractors by Promoters + Detractors. Set the format to Percentage.
Calculate the NPS score
Open Data Calculations.
Subtract Detractors % from Promoters % to calculate the NPS score. Set the format to Percentage.
Visualize NPS metrics on a Databoard
Next, you can add all new metrics to a Databoard and visualize them using different visualizations.
