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! 🙂
