Skip to main content
Solved

Impact of multiple property values on 'where' and 'group by'

  • January 26, 2022
  • 1 reply
  • 308 views

Suppose the event stream for a single user is:

  • Monday: ImpressionEvent #1 topic=(none)
  • Tuesday: ImpressionEvent #2 topic=dogs
  • Wednesday: ImpressionEvent #3 topic=cats

If I group-by ‘topic’ for the last 7 days, which value is used for the grouping? What about filter?

What I’m seeing is that the earliest value of `topic` is used in the group-by → but that has the consequence that some users with topic=(none) in the segmentation chart, actually have topic=cats when you inspect the user profile page.

Is this the expected behavior of am I doing this wrong?

Best answer by Saish Redkar

Hey @mikewillekes 

Here’s an Amplitude article which explains the above scenario really well -

https://help.amplitude.com/hc/en-us/articles/360016257391

So when you are clicking on the topic=(none) group in your event segmentation chart , here’s the most likely scenario - that user would have sent the event with topic=(none) as the property at that time and then they would have sent their last event with topic = cats ( which is the latest reflected property in the user profile ).

Let me know if I have interpreted your use case correctly. Hope this helps.

View original
Did this topic help you find an answer to your question?

1 reply

Saish Redkar
Expert
Forum|alt.badge.img+10
  • Expert
  • 1382 replies
  • Answer
  • January 26, 2022

Hey @mikewillekes 

Here’s an Amplitude article which explains the above scenario really well -

https://help.amplitude.com/hc/en-us/articles/360016257391

So when you are clicking on the topic=(none) group in your event segmentation chart , here’s the most likely scenario - that user would have sent the event with topic=(none) as the property at that time and then they would have sent their last event with topic = cats ( which is the latest reflected property in the user profile ).

Let me know if I have interpreted your use case correctly. Hope this helps.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings