Solved

max(timestamp) - min(timestamp) per user?

  • 9 September 2023
  • 1 reply
  • 95 views

Badge

Hi,

 

I’d like to measure the overall time a user has been using the product (“seniority”) by subtracting the timestamp of their first event from the timestamp of their last event, then average that per month (i.e. the average seniority for users who used the product over the last 30 days. Is there any way for me to do this in Amplitude?

 

Thanks,

Eyal

icon

Best answer by Saish Redkar 10 September 2023, 18:56

View original

1 reply

Userlevel 7
Badge +10

Hi @Eyal Bukchin 

I feel that exploring the sessions chart could be a much simpler approach. The end result format might not be exactly what you are looking for, but worth trying it out. Here’s a demo chart for avg session length by user - https://app.amplitude.com/analytics/demo/chart/new/u63vkaqc

Hope this helps.

Reply