Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have users and mobile app analytics data (events aggregated into sessions based on the time interval between two consecutive sessions for a same user).
In my Qlik Sense app, I want to measure the number of active users defined as the number of users that have created more than X sessions within the last 7 days with the condition that at least two of those sessions are separated by at least Y seconds.
Also, to simplify the discussion, let's assume the following features:
[userId, sessionId, sessionStartTimestamp]
I am struggling with the part highlighted, if anyone has any idea how this could be achieved, that would be much appreciated! 🙂
@confused-pandas can you share a sample data and the expected output ?