I’m trying to figure out how I can link two events that share the same event property value. An example would be, I want to get the average time between an event ‘POST_CREATE’ with property {id: ‘some-unique-id’} and ‘COMMENT_CREATE’ with property {post_id: ‘some-unique-id’}. There are some other funnel charts I want to make that would need to tie these events in a similar way.
I can specify a particular id if I use ‘where’ like so:
But that will only give me the time for a particular post, not all of them.
Best answer by Saish Redkar
Hey @jtambunt , Not quite sure if I’m interpreting this correctly, but looks like you are trying to build a funnel chart and hold the post_id property common for the events ?
If this is the case, then you can use the holding constant clause in the funnel chart. But to use this, both the event properties should have the same name.
Here are some resources on the “holding constant” feature
Hey @jtambunt , Not quite sure if I’m interpreting this correctly, but looks like you are trying to build a funnel chart and hold the post_id property common for the events ?
If this is the case, then you can use the holding constant clause in the funnel chart. But to use this, both the event properties should have the same name.
Here are some resources on the “holding constant” feature
It is the case that “holding constant” would be the best feature available to achieve what you have described. Along with emphasizing @Saish Redkar’s note that the event properties you want to hold constant should have the same name across events, I’d also like to note that you will only be able to hold constant with an event property if it is available in all the events in the Funnel Analysis.
@Saish Redkar, that is a nice feature, thanks for point it out!
However, I believe that in this particular use case, it would be better to hold the Post ID constant, but keep the “user free”, since the objective is finding out the average time between a post is created and replied by any user, not the same user who created the post.
Would it be possible to make this analysis using Amplitude?
@jtambunt, did you get the result you were expecting or you also need to consider any user in the comment event?
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. You can also create a Guest account below!
If you're a current customer, select the domain you use to sign in with Amplitude.
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. Want to sign up as a guest? Create a Community account.
If you're a current customer, select the domain you use to sign in with Amplitude.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.
