You can calculate Distance Travelled automatically

Steps

You must have a Progress Board that contains the Multiple Choice Questions that you want to analyse Distance Travelled for. (How to add Multiple Choice Questions to a Board)

Go to the Progress Board containing the Multiple Choice Tracker on the project(s) you are analysing
Click the title of the Multiple Choice Tracker
This causes the Card Popup to launch

Explore the data

Every pair of start points and end points is a Distance Travelled ‘Journey’.
- For example, going from Moderately Disagree to Slightly Disagree is a Journey
There are two ways to display the different journeys:
- Chart view
- Table view
By default the data loads in Chart view - there is a line for each journey
Select the Table radio button to toggle to Table view where there is a row for each journey
In table view you can see the
- number of contacts who did each journey
- percentage of contacts who did each journey
- names of contacts who did each journey
- first story and last story of each contact who did that journey

Start by selecting the Table radio button to toggle to the Table view
Click the title of each Journey (distance that was travelled) to expand the row and display the contacts who did each journey

Access the table view of the Distance Travelled dataset
Expand the row for the journey you want to investigate further
The list of contacts who made that journey are displayed
“Start” and “End” appear next to the name of each contact
Click either to launch a popup that contains details of when the story (survey response) was completed
Press View Response to be taken to the story (survey response) for that contact
You will arrive on the Answers tab of the story page.
If it is blank, click the Summary tab and then select the Answers tab again
The answers for that contact are displayed
If the story contains survey responses for multiple contacts you will see a row for each contact below each question.