Building user funnel

1

Hello,
I need to build user funnel for web application. I could not find any viable ‘yes’ or ‘no’ in docs and in wild internet, so I’m asking here, maybe someone already done this.
Is it possible to build user funnel with Influxdb?
What I have:
time | visitor_id | event
123 | 1 | sign_up
124 | 14 | sign_up
125 | 23 | sign_up
126 | 23 | choose_plan
127 | 23 | payed
128 | 14 | choose_plan
129 | 44 | sign_up

OR

time | visitor_id | event
123 | 1 | sign_up
124 | 14 | sign_up
125 | 23 | sign_up
126 | 23 | sign_up:choose_plan
127 | 23 | sign_up:choose_plan:payed
128 | 14 | sign_up:choose_plan
129 | 44 | sign_up

I need to build user funnel by visitor events, in sql I would use self joins and in Influxdb is it possible?

Thanks in advance,
Grigory

2

@Grigory_Antonov I think it would be possible. I would model it this way in line protocol:

users,visitor_id=5qmOmXjHQgJY53J,event=sign_up value=1 1492215105
users,visitor_id=ThrE50h5nmqt419Q,event=choose_plan value=1 1492215105
.....

This would be a very performant measurement as well.