In our lake we store multiple date times, specifically for our use-case a postgress database with columns utilizing timestamp with time zone, nullable.
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áčekView original