我有一个示例数据集,看起来像这样:
事务ID | 会话 | 1 | 1 | 2
---|---|
1 | |
3 | 1 |
2 | |
2 | |
3 | |
空 | 4 |
空 | 4 |
一个选项是只计算带有事务的会话的session_id,然后除以总会话:
SELECT COUNT(DISTINCT IF(transaction_id is not null, session_id, null)/COUNT(DISTINCT session_id) as ratio
FROM sessions_table