I'm attempting to create a map that shows city pairs. In my data I have the two cities listed in the same row, but each row has the same path count of 1. As a result, I had to duplicate the rows of data and change the path count from 1 to 2 in order to visualize this data on the map. This lends me with double the data that I actually need and puts a strain on the system when I attempt to open this dashboard.
Does anyone know of a way to show these pairs without duplicating each row of data?
Would you be able to share this workbook? Or at least a sample so we can see the issue you're running into.