Expand my Community achievements bar.

What are the calculation rules for total spent time?

Avatar

Level 2

Hello,

   I am currently subscribing to data from a data feed, loading it into a database via SFTP for analysis. I would like to ask about the calculation rules for the 'total spent time' metric. Which fields are used and what logic is applied to calculate it? I need to ensure that it aligns with the values in the workspace.

leozh1_0-1732157838826.png

 

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply

Avatar

Level 2

My current calculation rules are:

page_name            post_cus_hit_time
page A                          11:00

page B                         11:01

page C                         11:03


page A total spent time is 11:01- 11:00 = 1 minutes

page B total spent time is 11:03-11:01= 2 minutes

However, this result is different from the one in the workspace.