Solved

Number of events per day for a user

  • 18 July 2022
  • 1 reply
  • 469 views

Hello!
Users have event X
Event X has property Y
1. I need to take all users who have more than 5 events X per day
2. Calculate the median of property Y

And I don't understand how in amplitude I can create a cohort of users who have >5 specific events each day in 30 day range.
I hope for your help!

icon

Best answer by Tatiana 18 July 2022, 16:46

View original

1 reply

Userlevel 2
Badge +1

hi @m.efremov 

the segmentation chart is a great option to build your analysis, 

event x → “Purchase Song or Video”

property y → “$revenue”

  1. use “who performed” clause to filter those users who triggered an event of your preference equal or more than 5 times and specify “any time” a range
  2. the median would be calculated based on the property you choose in the “grouped by” clause under the event.

Once the chart is built, you could create a cohort of each day if your chart is a line chart, but also you can convert it to a bar chart and select the (30 day) range of your preference to create the cohort.

 

hope it helps, 

 

Reply