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?
LinkedIn
Twitter
