Duration in line chart

Hi there

In a line chart, I would like to display the trend of a duration (call duration). The data comes from a Google Sheet, where I have stored it in the following format: 0:00:00 (column formatted as “duration”). Unfortunately, the values cannot be displayed in Looker Studio… Can you help me?

According to Dates and times  |  Looker Studio  |  Google Cloud Documentation, duration dimensions need to be expressed in seconds. You could use a calculated field to parse out the hours, minutes, and seconds and convert it all to seconds.

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.