[GitHub] [doris] AlisaSmiler opened a new issue, #15947: [Feature]

[GitBox <gi...@apache.org>]

AlisaSmiler opened a new issue, #15947:
URL: https://github.com/apache/doris/issues/15947

   ### Search before asking
   
   - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues.
   
   
   ### Description
   
   <img width="994" alt="image" src="https://user-images.githubusercontent.com/13227979/212581649-6b2781c8-b26a-4142-b659-413d40a8139d.png">
   希望有个类似window_funnel的函数，可以计算在漏斗转换过程中用户的平均转化时间，比如用户1漏斗深度是2，那么从A到B的时间是多少，从B到A的时间是多少，这样有明细了，就可以计算漏斗每一步的平均转换时长
   
   ### Use case
   
   select t.xwho,
      window_funnel_level_time(3600 * 10,
      'default',
      t.xwhen,
      t.xwhat = 1,
      t.xwhat = 2 ,
      t.xwhat = 3,
      t.xwhat = 4) AS `funnel_level_time`,  -- 是一个列表，第一个元素表示深度，后面的数据表示转化时间，例如2,1000,1001
     from
      windowfunnel_test t
     group by t.xwho
   
   
   
   ### Related issues
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [X] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org