To GoodData homepage

Topics started by JeffC

4 Topics

JeffC
JeffCParticipating Frequently
asked in Metrics and MAQL

Null Value - Unanswered Phone Calls missing

I have a table of phone call facts, that includes a foreign key to a users table.  When making dashboards, things have been going well as long as the phone call is answered - because the user_id field is populated and aligns with a worker.  Unfortunately, some calls are not answered so the user_id for that row’s column is null. Once I add the full_name to the insight, all of the rows missing a name due to the foreign key disappear (but are still included in the roll up).  I’ve referenced the how-to guide but something isn’t clicking for me how how to cater this to my call center use-case. Can anyone access my account (admin has access from prior ticket) to tell me what I may be doing wrong?  This is a stopper for our migration.

1
Moises Morales
GoodData Employee
1 year ago
JeffC
JeffCParticipating Frequently
asked in Metrics and MAQL

Date Time - Date Time

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:00call_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?

3
Radek Nováček
GoodData Employee
1 year ago
JeffC
JeffCParticipating Frequently
asked in Metrics and MAQL

Rollup/ Aggregation Wrong

I have a simple table that has an attribute of ‘Resource Direction’ and an attribute of ‘Call Sid’.  I’ve created a metric called Actual Calls Offered, and am trying to select and count all ‘Call Sids’ where Resource Direction = ‘inbound’ OR ‘Resource Direction = ‘inbound with attached outbound’.  The value comes back as 135 records, when I query the database I have 142.  When I add the insight, I get the wrong value of 135, but when I add a row to split the data, the row level data is accurate.  114 + 28 is NOT 135 as shown in the screenshot. SELECT COUNT(Call Sid) WHERE (Resource Direction = inbound OR Resource Direction = inbound with attached outbound)Edit - I tested in insights without using metrics and see the same roll up behavior that matches my metric, but seems accurate when SUM is utilized. 

8
Joseph Heun
GoodData Employee
1 year ago
JeffC
JeffCParticipating Frequently
asked in Data models

Updating Data Models when Souece Updated

So I have a postgress database that has been updated to add new columns. However, my data model doesn't seem to pick these up or volunteer that they were found so that I can choose to add them for future loads. Without breaking metrics how can I add the missing columns in the least manual way?  

3
Iva Gasparekova
GoodData Employee
1 year ago
Welcome to the GoodData Community!Cookie settings