I'm sure there is a very simple way of doing what I want to do, but I seem to be having a blonde moment ...
I have an Excel spreadsheet of a few thousand telephone calls: Originating number, receiving number, date and time of call, cell tower used, etc. What I want is to have a directed graph of all the calls between the various telephone numbers, I want to use
a filter so that I can choose two dates and then have the graph display only those calls between those dates, the more the calls, the thicker the edge.
I have input the originating number as Vertex 1 and the receiving number as Vertex 2 in the Edges tab. I then renamed Column N (Other columns) to Date and pasted the date/time for the call refered to in Vertex 1 and 2. I have also input the subscriber's
name and telephone number in the Edges sheet. The graph is Directed.
What is the best way to choose between two dates? Dynamic Filter gives some weird numbers to choose from and using custom filters works ("All dates in the period", but then I have difficulty including the subscriber's names as that edge does not
have a date.
1. How do I create an Edge label that shows the number of edges (without merging the edges)?
2. Is it possible to have the Label column in the Vertices tab automatically populate with the vertex name in column A?