This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

connecting google sheets "duration" to looker studio *attached photos

Posted on 11-19-2024 10:02 AM
graceingold
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

the numeric format in google sheets for the TSL row is "duration" and formatted HH:MM:SS.  When I connect the sheet as a data source in looker, I put that as "duration" as well but I'm only getting null in the report. Can anyone help?

 

3.png2.png1.png

0 2 302
Topic Labels
0 Likes
2 REPLIES 2

Posted on --/--/---- --:-- AM
sitchey
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

Hi. Did you figure this out? Im having the same problem with duration in Google Sheets and Looker not displaying them in the same format

0 Likes

Posted on --/--/---- --:-- AM
shijithpulikkal
Bronze 2
Bronze 2
Reply posted on --/--/---- --:-- AM

Hi,

you need to convert HH:MM:SS in to seconds in googlesheet itself using another column.. you can try this formula.. =ARRAYFORMULA(IF(G2:G<>"", G2:G*86400, ""))
  and you can use this new column in LookerStudio and its data type to Duration .. 

Xtract Studio

0 Likes