Report length on page/portal visit

[dagarson]

Hello Is there a way I can create a report that would capture the average length of time a user spends on a service portal page or the service portal itself?

Thank you

[shloke04 · Accepted solution]

Hi,

You can do this by making a Report on SP Usage(ua_sp_usage) table which captures this information as shown below:

Report Type  =  LIST

Click on Save and view the result. If needed filter on a field if you want as well:

this report gives you info about when the user started and ended for a portal.

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

[shloke04]

Also to note here there is another table named "SP Log (sp_log)" which captures specific details about say each page which a user had accessed and you can also a build a report on this as well.

Report Type : List:

Refer to screenshot below on how this would look like:

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

[dagarson]

This is helpful but is their a duration I can capture? I see a start time and end time is their a way to capture the amount of time between the two?

[shloke04]

Yes, you can achieve it within your report only. There is a concept named as "Function" which exists in Report itself.

Please follow the steps to achieve this:

1) In your Fist report shown above on Table as SP Usage, on 3rd Tab named as "Configure" click on Configure function field as shown below:

Now here you can select Start and end Date Time Fields and calculate the Duration and show it in your report as shown below:

Give a Name of a Label and make sure to select Return Type as Duration.

Then Select Operation as datediff and finally select the fields as end first and then start as shown below:

Now you need to add this label say for example "Time Duration" as shown above to the columns by clicking on "Choose columns" as shown below and select your function variable as shown below:

Final Output:

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke