Creating complex ranking using certain values within a dimension
I am attempting to create a sankey diagram that shows a customers activities leading up to a certain conversion. Each customer can have multiple conversions so I want to rank each activity leading up to a conversion, and have that rank reset after the conversion happens. Having some trouble theorizing how to do this in a dataflow or SQL.
In the sample data above, it is easy to create the ranking by partitioning by USER and ordering by date.
I am trying to create the journey and journey rank fields.
Journey: Each journey should include the activities leading up to and including the conversion
Journey Rank: the order of activities leading up to and including the conversion (should reset after the conversion happens). The journey rank should start over for every specific journey.
Hopefully there is an easy solution I am not considering! Thanks in advance.
- 10.7K All Categories
- 13 Getting Started in the Community
- 41 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.5K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 303 Use Cases & Best Practices
- 503 APIs
- 120 Apps
- 48 News
- 753 Onboarding
- 1.2K 日本支部
- Private Company Board