18F / identity-analytics-etl

ETL and SQL scripts for Login.gov data warehouse and business intelligence
10 stars 6 forks source link

Sanhe/funnel view version2 with device remembered #202

Closed MacHu-GWU closed 5 years ago

MacHu-GWU commented 5 years ago

labels: task

Summary

Addresses Issue # LG-1023

Please note if fully resolves the issue per the acceptance criteria: Y

Describe the pull request here, including any supplemental information needed to understand it.

This is Funnel View query version2. The major update is that we require 'Email and Password Authentication' is success and remember_device is True. It is a more reasonable criterion for Funnel View Analysis. Detailed change is documented in the Authentication-Funnel.sql file.

This pull request changes...

This pull request is ready to merge when...

MacHu-GWU commented 5 years ago

Since Laura did a git-branch-filter, lots of git history are changed. So just Close this PR and rebase this branch from the latest master. And issue another PR for this.