usgs-makerspace / makerspace-sandbox

Some initial R code for playing with data processing (maybe some light visualization).
Other
0 stars 5 forks source link

Average for page load across all pages #493

Open wdwatkins opened 4 years ago

wdwatkins commented 4 years ago

It would be useful to display an average page load across all pages for an application. This could be done in the pipeline, or maybe in Tableau?

mhines-usgs commented 4 years ago

Looking at this today to see how I could implement it in Tableau.

mhines-usgs commented 4 years ago

If I'm understanding this correctly, are we talking about a single value for each application? Could I sum and average the current data I have in the page load 30 days dataset? Or would that be incorrect? (average of averages?)

wdwatkins commented 4 years ago

You would need to account for the number of samples for each page. So for each page, compute total load time (sample size x avg load time), sum that across all pages for each app, and divide that by the sum of sample sizes for each app