Connecting events with the same event property value

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 27 May 2021, 22:51

View original

3 replies

Userlevel 7
Badge +10

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


Let me know if this fits your use case or not.


Userlevel 3
Badge +5

Hello! Thanks for your question.

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. 

Here is an example of a Funnel Chart from our Amplitude demo where the “holding constant” feature has been applied:



Userlevel 1

@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?

Thanks in advance!