Forum Discussion
Create Table Relationship
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.
Apologies. It let me filter but had issues with something else. Let me re-create the problem.
It doesn't work. I picked the wrong date to filter earlier. I tried to filter by Company where all the companies had records for a day but it shows all the agents for all the companies.
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?
I found why I was getting Many to Many error with Agent and Company. Same Agent name was found in more than one company. After sorting that out I moved the Company to the Agent table as you suggested and built the relationship. That is working now.
Thanks for your help.
