Skip to main content
Solved

Look up a list of users by an event property value beyond 24hours

  • January 11, 2023
  • 1 reply
  • 365 views

Forum|alt.badge.img
  • Conversationalist
  • 6 replies

Hi team, 

We have an event that contains the error type in its property. Think of the event being “on_error” and the property giving us the error code specifically. 

We need to create analytics and perform lookups of all users that experience the on_error event with specific property values. We want this in list form with the associated User ID’s, not a simple graph or view to spotlight how many occurrences happen. 

Is this possible? If so, how would we do this?

 

Thanks so much for the urgent help. 

Best answer by Saish Redkar

Hey @adam12 

One way I can think of is to create an event segmentation chart and group by error code and user id for your desired time range. You can then export the csv of this chart ( the option above the breakdown table ). Here’s a demo chart -  https://analytics.amplitude.com/demo/chart/new/v5oevk4

Another approach would be a Data Table for the same grouping combination of properties.
Similar to this - https://analytics.amplitude.com/demo/chart/new/lv6j4la . This too can be exported and could serve as a better formatted list than the event seg chart csv export.

I think this is the closest result you can get for your user IDs and specific event property values to be in a list format.

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
  • 1380 replies
  • Answer
  • January 12, 2023

Hey @adam12 

One way I can think of is to create an event segmentation chart and group by error code and user id for your desired time range. You can then export the csv of this chart ( the option above the breakdown table ). Here’s a demo chart -  https://analytics.amplitude.com/demo/chart/new/v5oevk4

Another approach would be a Data Table for the same grouping combination of properties.
Similar to this - https://analytics.amplitude.com/demo/chart/new/lv6j4la . This too can be exported and could serve as a better formatted list than the event seg chart csv export.

I think this is the closest result you can get for your user IDs and specific event property values to be in a list format.

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