Forum Discussion
Solved
Create Table Relationship
Hi, I am trying to join the following three tables without success. Can someone please help? Currently I have joined the Date table to Calls and Agent Times tables using Call Date. A...
Do the agents belong to a company? Is that an attribute you could move up to the Agents table? What are you trying to calculate off the Agent Times table?
You will need an Agent table that sits at the same level as the date table. It should contain the unique list of agents and that you can connect to the 'Agent Time' and Calls table to use to filter the model by Agent.
Already tried that and that didn't work. My new report is based on the Agent Times table and it doesn't let me filter using anything on the Calls table. For example, it doesn't let me filter by Company.