Forum Discussion
(Yet another) time query
I think I've solved it myself!
I was asking for daily data, and Power BI was trying to average, but by removing day from my query, it is retuening the expected results.
Thanks for your help!
Thanks Vivran
So the Duration button has given me the seconds I need, however, I'm now trying to replicate the Average Time on Page and Bounce Rate metrics from Google Analytics.
When I put my measures in a table I see the following:
However , the totals are different (in some cases as much as 5%) from those that Google Analytics are reporting.
As you can see from the table, I've tried weighting the average to minimise the difference, however it is still enough to render the table completely innaccurate to it's audience.
Is there a calculation method I'm missing to get this closer to the mark?
Daniel
What is the calculation of average and is it possible to share the sample data and the expected results from google analytics?
Rgds,
Vivek
I think I've solved it myself!
I was asking for daily data, and Power BI was trying to average, but by removing day from my query, it is retuening the expected results.
Thanks for your help!