In our lake we store multiple date times, specifically for our use-case a postgress database with columns utilizing timestamp with time zone, nullable.
call_start_time: 2023-01-14T16:32:25+00:00
call_end_time: 2023-01-14T16:35:16+00:00
We don’t have a calculated column today, nor are we calculating at insert so we’re trying to create a metric that selects the average of call end time - call start time). Since things may cross over the 24 hour mark and of we want to present data stored in UTC across different timezones, I’m looking for a way to make this work.
In SQL it would be something like:
SELECT AVG(TIMESTAMPDIFF(SECOND, call_start_time, call_end_time)) AS avg_time_not_answered FROM your_table_name WHERE Interaction_handled = 0;
How can I replicate this in Gooddata, secondly, what is the easiest way to change visualization of our data into a selected timezone?
Best answer by Radek Nováček
View original