Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Google Analytics Duration in PowerBI

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...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

Gabriel_Walkman's avatar
Gabriel_Walkman
Icon for Continued Contributor rankContinued Contributor
5 years ago

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] )

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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