连续类指标计算方法,比如连续登录天数、连续领取天数等等指标~
下面以连续登录天数为例,说下解决方法;
输入
每日login表
dt | user |
---|---|
20170601 | A |
20170602 | A |
20170603 | A |
20170601 | B |
20170701 | B |
20170702 | B |
20170801 | C |
20170802 | C |
连续类指标计算方法,比如连续登录天数、连续领取天数等等指标~
下面以连续登录天数为例,说下解决方法;
每日login表
dt | user |
---|---|
20170601 | A |
20170602 | A |
20170603 | A |
20170601 | B |
20170701 | B |
20170702 | B |
20170801 | C |
20170802 | C |