Try the following:
1. Create the calculated field similar to above:
[Time on Page] / ([Pageviews] - [Exits])
2. Create a second calculated field that takes the above calculation and divides it:
Then, change the format and add it to the field.
Hope this helps!
Thanks for your response.
I tried what you said as it is........But in the second step as you mentioned to use "sum([Calculation1])/86400" instead of "Avg([Calculation1])/86400"
The result value for Avg.Time on Page in Tableau report is so far from Google Analytics value.
If Avg([Calculation1])/86400 is used it's showing slight difference.
It's hard to say when I can't see the workbook/google results, but another option to try would be to aggregate the first calculation:
sum([Time on Page] )/ (sum([Pageviews]) - sum([Exits]))
Then, divide it by the 86400.
Did you ever figure out how to match your data to the GA data? I am facing the same issue. Thanks
2 of 2 people found this helpful
I know this post is old, but I thought someone may come across it.
I believe that you need to have the calculation setup like this:
(SUM([Time on Page])/(SUM([Pageviews])-SUM([Exits])))/60
I am not sure why 86,400 was the original divisor in the post, but this calculation should provide accurate results.
Thanks! It really helped!
24 hours = 86 400 seconds