Skip to main content
Solved

Calculate total time spent per user (Dynamic Table)

  • April 25, 2023
  • 1 reply
  • 338 views

Hello community, how are you?


Has anyone been able to plot a graph, using pivot table, with data of average time spent per session, total time spent per session, and average duration per session?


I know that User Sessions is the view where we can view this, but in this specific case I need to view it in a table format and by user.

Best answer by Saish Redkar

Hi @Guilherme Carvalho 

AFAIK, the user session metrics which are available in the user session charts can’t be utilized in any other chart format.

The only possible way is to use the sessions data table below the user session chart after applying a group by on user ID. Something like this demo chart - https://analytics.amplitude.com/demo/chart/new/76j77zb

Hope this helps.

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

1 reply

Saish Redkar
Expert
Forum|alt.badge.img+10
  • Expert
  • 1377 replies
  • Answer
  • April 25, 2023

Hi @Guilherme Carvalho 

AFAIK, the user session metrics which are available in the user session charts can’t be utilized in any other chart format.

The only possible way is to use the sessions data table below the user session chart after applying a group by on user ID. Something like this demo chart - https://analytics.amplitude.com/demo/chart/new/76j77zb

Hope this 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