Looker Connect Training

Help Center

Documentation

Community

Cloud Certifications

Topics started by Scott_Harris

1 Topic

Scott_Harris
Scott_Harris
asked in Dashboards & looks

Net Promoter Score calculation

Hello Looker community, I am looking for help in producing a visualization that displays the Net Promoter Score for one of our digital properties. In Looker, I have a column that, for each row, contains either “Detractor,” “Passive,” or “Promoter” as a value. I was able to use a table calculation to find the percentage of the total for each one of those categories. So in the “Results” section of “Data” tab in Edit Tile, there are three columns: the rating category, the total count per category, and the percentage of the total, with the second column hidden from the visualization. Now I want to subtract the percentage of “Promoter” from “Detractor,” arriving at a final numerical value. But I can’t quite figure out how to create a table calculation that produces it.

2
Brent Wiles
2 months ago

Badges

  • Friendly Face
    sbrylowskihas earned the badge Friendly Face
  • Helpful
    carriehas earned the badge Helpful
  • Community Star
    carriehas earned the badge Community Star
  • Friendly Face
    carriehas earned the badge Friendly Face
  • Community Star
    Dawidhas earned the badge Community Star
Show all badges
Terms of Service