Google Analytics Time on Site/Duration not updating

[mshaivitz]

Hi - I've pulled in the Session Duration metric from Google Analytics, and converted it to a time.

I'm using a Measure to display it in a Card on a dashboard - Measure 2 = CALCULATE(AVERAGE('Time on Site'[Session Duration].[Day]) )

It worked the first time I did it - my metric of time on site matched what was in GA - but it doesn't update. I'm not sure why because when I look in the Table View, I see up to date numbers.

Any help is appreciated.

[gpillai]

Hi, 

I know it's been a while, but did you find the solution to this by any chance? I'm facing the same issue. 

Thanks, 

G.  

[Eric_Zhang]

---

@mshaivitz wrote:

Hi - I've pulled in the Session Duration metric from Google Analytics, and converted it to a time.

I'm using a Measure to display it in a Card on a dashboard - Measure 2 = CALCULATE(AVERAGE('Time on Site'[Session Duration].[Day]) )

It worked the first time I did it - my metric of time on site matched what was in GA - but it doesn't update. I'm not sure why because when I look in the Table View, I see up to date numbers.

Any help is appreciated.

---

@mshaivitz

What is the data type of [Session Duration], date, datetime, time? What is the measure expected to output?

[mshaivitz]

Hi @Eric_Zhang - the data type for Session Duration is Date/Time with a format of HH:mm:ss. The measure/output is an average of the Session Duration column. Thanks.