Solved

Average Distinct Days per Cohort

  • 13 March 2023
  • 1 reply
  • 152 views

Hi, guys

 

I’m having some troubles trying to calculate the average amount of distinct days a cohort of users is active at my app and the compare them.

 

Using SQL will be an easy calculation, but I’m having a hard time trying to deliver this easy calculation. 

 

Would this be something I can set up using custom formulas or other specific analysis chart?

 

Thanks

icon

Best answer by Amplitude Admin 15 March 2023, 16:40

View original

1 reply

Userlevel 6
Badge +9

Hello @danochoa You can use the count in interval in the with drop down. Filter for users who triggered the event at least once on each of the number of distinct days within a given interval. See our Help Center article on how stickiness analysis works in Amplitude to learn more.

Reply