Are you looking for a free Periscope Data t-shirt?
Hey everyone! Welcome and thanks for joining!
If you're looking for a free t-shirt, please make a post or reply *with a datset, SQL snippet or something analytics related*, and add a photo and title with company to your account.
Then shoot me a private message or fill out this form.
Thanks and talk to you soon!
Some handy snippets for calculating NPS and accuracy.
((promoters/total ) - (detractors/total))
((1 - [NPS]) ^ 2 * promoters/total + (0 - [NPS]) ^ 2 * neutral/total + (-1 - [NPS]) ^ 2 * detractors/total)
select npsdate , total as sample_size , [NPS] as nps , (sqrt([NPS_VAR]) / sqrt(total)) as moe2 , (sqrt([NPS_VAR]) / sqrt(total)) as moe , [NPS] - (sqrt([NPS_VAR]) / sqrt(total)) as moe_lower from ( select [created:aggregation] as npsdate , count(1)::float as total , count( case when recommend <= 5 then 1 end )::float as detractors , count( case when recommend > 5 and recommend < 9 then 1 end )::float as neutral , count( case when recommend >= 9 then 1 end )::float as promoters from your_nps_survey_table group by 1 ) as respondents
You can use moe_lower, moe and moe2 to show error bars on results. Make moe_lower the same color as the background.