I'm working with users behaviour data in an app and I'd like to get analytic information related to the conversion of the users into the different events.
The data I have is as follow:
|User ID||Event||Success / Fail||TimeStamp|
|1||Launch the app||-||2016-11-02 11:30:45|
|1||Register in the app||Fail||2016-11-02 11:31:30|
|1||Register in the app||Success||2016-11-02 11:32:58|
|1||Select something||-||2016-11-02 11:35:22|
|2||Launch the app||-||2016-11-02 13:21:10|
|2||Register in the app||Success||2016-11-02 13:21:30|
|2||select something||-||2016-11-02 13:22:00|
|2||Add something||Success||2016-11-02 13:23:45|
|3||Launch the app||-||2016-11-02 13:30:02|
|3||Register in the app||Fail||2016-11-02 13:31:02|
|3||Register in the app||Fail||2016-11-02 13:32:04|
|3||Register in the app||Fail||2016-11-02 13:32:43|
|3||Close the app||-||2016-11-02 13:32:45|
|4||Launch the app||-||2016-11-03 09:20:55|
|4||Register in the app||Fail||2016-11-03 09:21:59|
|4||Register in the app||Success||2016-11-03 09:23:01|
|4||Select something||-||2016-11-03 09:23:55|
|4||Add something||Fail||2016-11-03 09:24:08|
|5||Launch the app||-||2016-11-03 10:55:45|
|5||Register in the app||Success||2016-11-03 11:00:01|
|5||Select something||-||2016-11-03 11:05:09|
|5||Add something||Fail||2016-11-03 11:10:13|
|5||Add something||Success||2016-11-03 11:15:15|
|6||Launch the app||-||2016-11-04 20:14:05|
|6||Add something||Success||2016-11-04 20:14:45|
And I'd like to get "Who of those users that launched the app went into successfully registered in the app, and of these users that successfully registered in the app, who went into select something, and of these users who went into successfully add something in less than 5 minutes."
In this case the answer is 2, as only user 2 completed flow in less than 5 minutes. So 16% of users who launched the app ended up the entire flow.
And the next question is "Who of those users that failed on registering in the app fo on to successfully register within 1 day" In this case the answer is user 1 and 4. So 33% of users who failed registering in the app go on to successfully register within 1 day.
What I mean is to get the typical funnel conversion with Qlik Sense expressions.
Thanks in advance!