About the data of Site Usage Analytics

%3CLINGO-SUB%20id%3D%22lingo-sub-2564387%22%20slang%3D%22en-US%22%3EAbout%20the%20data%20of%20Site%20Usage%20Analytics%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2564387%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20new%20to%20SharePoint%20and%20I%20found%20that%20there%20is%20a%20Site%20Usage%20report.%20I%20want%20to%20download%20the%20excel%20file%20%2290%20day%20site%20usage%20data%22%20to%20re-build%20the%20line%20chart%20on%20my%20side.%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20anyone%20know%20what%20is%20the%20formula%20for%20calculating%20the%20%22Avg%20time%20spent%20per%20user%22%3F%20More%26nbsp%3Bprecisely%2C%20how%20to%20get%20the%26nbsp%3B%22Avg%20time%20spent%20per%20user%22%20by%20using%20the%20excel%20file%20downloaded%20from%20SharePoint.%3C%2FP%3E%3CP%3EThank%20you%20so%20much.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22phchu1226_0-1626750624282.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F296981i6DFE9A21579B1673%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22phchu1226_0-1626750624282.png%22%20alt%3D%22phchu1226_0-1626750624282.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22phchu1226_2-1626750917630.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F296983i68A8F503C343261F%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22phchu1226_2-1626750917630.png%22%20alt%3D%22phchu1226_2-1626750917630.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECalvin%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2564387%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESites%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUsage%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Dear all,

 

I am new to SharePoint and I found that there is a Site Usage report. I want to download the excel file "90 day site usage data" to re-build the line chart on my side. 

Do anyone know what is the formula for calculating the "Avg time spent per user"? More precisely, how to get the "Avg time spent per user" by using the excel file downloaded from SharePoint.

Thank you so much.

phchu1226_0-1626750624282.png

phchu1226_2-1626750917630.png

 

Calvin

 

0 Replies