Hi everyone!
We’re trying to write a query that correlates multiple events using the data sketches but without success so far.
Generally speaking, the question we’re trying to answer is: how many events X occurs daily/monthly where event Y also occurred (W times in the last Z days) for the same user?
One of the several use cases is to answer questions like: how many orders (orderPlaced event) come from users who view a given blog post (contentViewed event) in the last 7 days? Or how many users upgraded their accounts (accountUpgraded event) up to 15 days after signing up (signUp event) ?
We’ve read everything available out there, but no success yet. Does anyone know if Druid supports queries like that?