Skip to main content
Solved

Number of events per day for a user

  • July 18, 2022
  • 1 reply
  • 913 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!

Best answer by Tatiana

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, 

 

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

1 reply

Tatiana
Helpful Hero
Forum|alt.badge.img+1
  • Helpful Hero
  • 9 replies
  • Answer
  • July 18, 2022

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


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