Page Comparison

...

• Turn on the ETL per instruction above, and wait overnight.

• Click “Ask a question”, then select “Custom Question”. Find the data source by searching for the table name (it will be under Analytics Main). The format will be data_STUDYNAME_end_of_study_survey

• Toggle to view in SQL, then convert to SQL.

• Copy the custom SQL below, replacing data_STUDYNAME_end_of_study_survey with the actual table name, and question_asking_for_nps with the question/column name.

  Code Block
  language sql
  SELECT CAST((( SUM(CASE WHEN question_asking_for_nps BETWEEN 9 AND 10 THEN 1 ELSE 0 END) - SUM(CASE WHEN question_asking_for_nps BETWEEN 0 AND 6 THEN 1 ELSE 0 END) ) / COUNT(*) * 100) AS int) AS nps FROM data_STUDYNAME_end_of_study_survey WHERE question_asking_for_nps IS NOT NULL

• Select the visualization type as Gauge, with the ranges configured as follows:

  Image RemovedImage Added

• Add to dashboard

...

NPS Score distribution

...