Hey, we're building an invoice approval solution. Users have multiple views like an inbox, an approval view, or an archive. Each view can contain multiple documents as todos: documents in your inbox, waiting for processing, open approvals, or all approved documents from the past in your archive.
We believe that the number of documents a user has in each view is important context to understand behavior. For example, if you only have two approvals, then you probably don't search. But if you have 100+ documents in your inbox, then you probably search a lot.
Our first idea was to attach these counts as properties to each page view event, but that would be too much load. So now we want to add a new event called dashboard_viewed
that is being fired each time a user visits the dashboard, which also happens to be the first page visited after login.
How can I combine the properties of the dashboard_viewed
event with other event data, like page views?
For example, I want to see how many searches (page_viewed
event where the search
property has any value) users do (probably a table visualisation) that have an open_approval_count
< 10 (property of the dashboard_viewed
event).
So the question is: is it possible to combine data from two different events, one for pre-filtering, the other one for getting the data?