Skip to main content

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

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