Forum Discussion
(Yet another) time query
Hello all I've recently linked Power BI to Google Analytics, and my customer wants to focus on Average Time on the Page. The data is brought into the model in a 'Duration' format, and look...
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!
Hi,
What is the calculation of average and is it possible to share the sample data and the expected results from google analytics?
Rgds,
Vivek
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!