Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I've pulled some GA data and selected 'time on page' to pull into the query editor. This automatically gets assigend 'duration' as the data type in the query editor which is correct, however when applyng to the report for build, the values update to decimals and duration data type is not found anymore.
See screenshots below. What would be a solution to getting it back to duration for reporting? I need to be able to present average time on a page.
Thanks
Solved! Go to Solution.
Thanks, I ended up splitting the values out as they were 0.00:00:00 so I could work with minutes and seconds indivually by transforming them.
Thanks again for your help
Hi!
I tried durations some time ago but could not get them to sum or average in a visual. I had to change the columns back to hours (as decimal) or minutes (as whole numbers).
Edit: oh yeah, there should be a 'Time' option under 'Data type' in your screenshot. Have a test yourself.
What values did you reproduce for minutes when selecting whole number as the data type? For me, 55 minutes would convert to 0 as a whole number.
For the data type time, this looks good but doesn't allow for the selectable measure average. Do you have any suggestions of how average could be put together via a custom measure?
Thanks
I converted duration to minutes in power query. I did not have to take seconds into consideration. New custom column =
Duration.Hours( [duration] ) * 60 + Duration.Minutes( [duration] )
Thanks, I ended up splitting the values out as they were 0.00:00:00 so I could work with minutes and seconds indivually by transforming them.
Thanks again for your help
@Anonymous , you can change data type to time and check
https://community.powerbi.com/t5/Service/Google-Analytics-time-duration-formatting-issue/td-p/107011
Hi @amitchandak
As per my thread with with Gabriel, for the data type time, this looks good but doesn't allow for the selectable measure average. Do you have any suggestions of how average could be put together via a custom measure?
Thanks
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |