Skip to content

Instantly share code, notes, and snippets.

@rex-lin

rex-lin/Moderation Performance

Created March 3, 2017 22:00
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save rex-lin/3b69b582b16cbc68a9dbbacfea3d5e8a to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save rex-lin/3b69b582b16cbc68a9dbbacfea3d5e8a to your computer and use it in GitHub Desktop.
Download ZIP
Moderation Performance
Raw
Moderation Performance
select date_created, moderator, sum(case when action_taken = 'FLIPAGRAM_MODERATION_APPROVED' then 1 else 0 end) as approved_count,
sum(case when action_taken = 'FLIPAGRAM_MODERATION_NOT_APPROVED' then 1 else 0 end) as not_approved_count
from pa.vw_interim_moderator_action
group by 1,2
order by 1,2 asc
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment