请问TIDB有漏斗分析函数吗?
类似Clickhouse的窗口漏斗函数WindowFunnel
select
count(1) as a , --完成4步总数
sum(if(funnel=4,1,0)) as fo , --提交订单人数
sum(if(funnel=3,1,0)) as th , --添加购物车人数
sum(if(funnel=2,1,0)) as tw, --点击广告人数
sum(if(funnel=1,1,0)) as one --看广告人数
from
(select
guid,
windowFunnel(1000000)( --1000秒窗口