Solved

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.

icon

Best answer by Saish Redkar 27 May 2021, 22:51

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

https://help.amplitude.com/hc/en-us/articles/360054203872#h_01ET6K2HGVAFG1J3V3QM4D7CJC

https://help.amplitude.com/hc/en-us/articles/360053338671#holding-properties-constant-and-session-based-funnels

 

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

 

View original

2 replies

Userlevel 5
Badge +4

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

https://help.amplitude.com/hc/en-us/articles/360054203872#h_01ET6K2HGVAFG1J3V3QM4D7CJC

https://help.amplitude.com/hc/en-us/articles/360053338671#holding-properties-constant-and-session-based-funnels

 

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

 

Badge +1

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: https://analytics.amplitude.com/demo/chart/new/yl1mpik.

 

 

Reply