日期:2014-05-16  浏览次数:20453 次

还是计算老用户和活跃用户的问题
老用户就是创建时间不是分析当天的,但是当天有访问过业务的用户
比如表A
ID         USERNAME           TIME             老用户
1                   aa                  2014.1.1                        
2                   bb                  2014.1.1                          
3                   cc                   2014.1.1           0
4                    aa                  2014.1.2             
5                   bb                   2014.1.2            2
6                   aa                  2014.1.3             
7                    dd                  2014.1.3             1
8                   aa                   2014.1.4
9                    bb                  2014.1.4              2

最后输出展现当天的结果                老用户              TIME
                                                               2                     今天

还有个问题前面其他帖子我也问了,但是感觉还