Question

Add Hours (Sum)

  • 30 August 2022
  • 0 replies
  • 16 views

Hi,

I’m building a dashboard where I export the hours data. I’m working with Google Cloud BigQuery to Looker, but when i try to sum the hours i got an error. With I take the data on format time, they can’t sum, because Looker recognizes time like string. If I send the data in minutes like integer i can convert on Looker to time, but i still can’t sum the hour to build my dashboard. If I sum first and then convert, the convertion gets wrong. And if I convert first and then sum, I got an error from Looker.

Someone knows how can i sum the hours on looker in this case?


This topic has been closed for comments