Solved

How can we filter based on "If user_property has been X, show all previous events"?

  • 20 February 2023
  • 3 replies
  • 111 views

In our specific use case we want to filter our graphs based on a custom user_property called “Department” and “Job title”.

 

We have just used the HTTP V2 API to enrich our user information in Amplitude with that information. However, when we set up the graph it only shows from the date we added the new information.

 

We want to be able to show a graph that displays weekly active users over time for all users who have the property “Department: Accounting”.

 

How can we solve this?

icon

Best answer by Saish Redkar 21 February 2023, 22:35

View original

3 replies

Userlevel 6
Badge +9

Thanks for sharing these details @sgaestaid This is an interesting challenge. Here’s more info on managing events and properties. Keep us posted as you make progress. 

Userlevel 7
Badge +10

Hey @sgaestaid 

If you are trying to use an event seg chart with the user property filter on Department, then you will only see the results from the date the events started getting stamped with those user properties. This is the expected behavior.

The alternate approach to include these users will be to create a behavioral cohort and apply that to your event seg chart. Do you have access to the this feature?

For this cohort, the user property clause could be : had user property Department = Accountinganytime since <date you enriched data >.

Depending your use case, you can either use anytime or most recently clause as explained here:

https://help.amplitude.com/hc/en-us/articles/231881448#user-property-clauses

 

 

 

Hey @sgaestaid 

If you are trying to use an event seg chart with the user property filter on Department, then you will only see the results from the date the events started getting stamped with those user properties. This is the expected behavior.

The alternate approach to include these users will be to create a behavioral cohort and apply that to your event seg chart. Do you have access to the this feature?

For this cohort, the user property clause could be : had user property Department = Accountinganytime since <date you enriched data >.

Depending your use case, you can either use anytime or most recently clause as explained here:

https://help.amplitude.com/hc/en-us/articles/231881448#user-property-clauses

 

 

 

Unfortunately I do not have access to that as we are on the starter plan. I suppose it is impossible to do without upgrading packages.

Reply