Forum Discussion
Unable to create multiple relationships on a column
I am trying to create a call log report in which I have two tables. One for the extensions and another with the actual call logs. I would like to create a visual which shows all calls for an extension whether they originated or were placed to the extension but when I try to create the relationship it only allows one active. In the image below I created a relationship between the extension on the left and the ToNumber and FromNumber columns on the right. Any idea how I can accomplish this so I can show all calls either incoming or outgoing for a single extension? Thanks!
2 Replies
You could try creating the relationships you need through merging your tables in the Query Editor
You could unpivot the calls table so there is a seperate row for incoming and outgoing details and a single column for number. You would have to be carefull not to double count the calls then though.
