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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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