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.
Best answer by Moises MoralesView original
Could you please let us know how was your metric defined? If you are not getting any data it may also be due to how your LDM is constructed, I recommend checking the connection points.