Trulyp Analytics

Build an interactive travel diary with Trulyp .

I built My Travel Diary, an interactive dashboard that keeps my travel memories in one place and lets me add new trips as I go. In this blog, I'll walk you through how I built it, so you can create your own travel diary, too.

Interacetive travel dashboard

What if you could keep all your travel memories in one interactive dashboard?

Last year, I built My Travel Diary in Tableau: a dashboard that keeps my travel memories in one place and lets me add new trips as I go. You can explore the original Tableau dashboard and read about how I built it in the Iron Vizzy spotlight

This time, I wanted to try something different: can I build the same dashboard in Trulyp? Short answer: yes. The same data, the same map with travel routes, the same counters and charts, and the same passport button that opens a form to add new stamps. Everything lives in one place, from the data to the write-back form.

In this blog, I'll walk you through how I built it, so you can create your own travel diary, too.

Step 1: Bring in the data

I started with the same Excel sheet as before: my trips, each with a departure, an arrival, the country, city and continent, the coordinates of both ends, start and end dates, the trip type, the transport and whether it is a future trip.

In Trulyp Analytics I created a new dashboard, opened the Data tab and chose Import Excel or CSV. Trulyp reads the columns and suggests a type for each one (text, decimal, date or boolean). I picked the WriteBackExtreme connection and clicked Create and import.

That one click does three things at once:

  • It creates a WriteBackExtreme table with all my trips in it.
  • It builds a semantic model on top of that table.
  • It connects the model to my dashboard.

In Tableau, the data source and the write-back table were two things I had to keep in sync. Here they are the same table from the start, so every new stamp shows up on the dashboard straight away.

Tip: format your dates as plain text (2023-06-15) before you import.

Step 2: Create a map with travel routes

The map is the heart of the dashboard. The route lines from the latitude and longitude of each trip show the travels that are made and with the tool 'Map – markers' the lines are automatically created for you.

  1. Add a Map – markers visual.
  2. Put Departure LAT and Arrival LAT on Latitude, and Departure LOI and Arrival LOI on Longitude.
  3. Set the aggregation to AVG, so places I visited more than once stay in the right spot.
  4. Use id as the label, so every trip becomes its own route.

As soon as there are two coordinates per trip, Trulyp draws smooth travel lines between them, with a dot at each end. These lines and dots are fully customizable so I set the line colours, the dots and thickness of the line. From Vorden to Berlin, Sri Lanka to Bali, and Amsterdam to Perth: all the arcs are back.

Step 3: Counters, charts and future trips

On the left side of the dashboard I tell the story in numbers.

  • Counters. Two KPI cards count the continents and countries I have visited.
  • Bar charts. One bar chart shows my trips per continent, and one shows them per trip type.
  • Future trips. A small HTML visual lists the year and country of every trip that is still coming up.

The trick is keeping the past and the future apart. My future trip to Perth should not count as a country I have already visited. I solved this with two filter objects on the Future Trip field: one set to past trips for the counters and charts, and one set to future trips for the list. Trulyp saves the selected filter values with the dashboard, so I hid both filters in the Layers panel. They keep working in the background, nobody sees them, and my dashboard stays clean and aesthetic.

Step 4: Arrows, notes and the passport

What makes this dashboard mine is the extras that I like on top: hand-drawn arrows, little notes and the passport with, of course, Vizzy.

In Tableau, I used floating objects to create this. In Trulyp, you switch the dashboard from Grid to Freeform in the Layers panel. In Freeform, visuals can overlap, so I could place my extra elements over each other, just like before.

  • Arrows. Each arrow is an Image object which can be easily uploaded.
  • Notes. "and counting...", "Coming up!" and "Add new stamps" are small text objects.
  • Passport. This is a Button object with Use image as button switched on. The closed passport is the normal image and the open passport with all the stamps is the clicked image. One click and the passport opens.
  • Clean tiles. I hid the titles, borders and backgrounds of all visuals, so everything sits on one calm background.

Step 5: Add new stamps with WriteBackExtreme

In my opinion, a travel diary is only truly useful if you can keep adding to it, keeping your travel memories alive along the way. In Tableau, the passport opened and closed my form. In Trulyp, I used the built-in Add Data visual for this for this. It gives you a real form that adds new rows straight into your WriteBackExtreme table.

  1. Make the fields friendly. In WriteBackExtreme → Schemas, I opened the table that the import created. Under Fields I changed Continent, Trip Type and Transport to Dropdown select and typed the options one per line, as value: label (for example Europe: Europe).
  2. Add the form. In the dashboard I added an Add Data visual, opened Use an existing table and picked my trips table. Trulyp turned all 14 columns into form fields: text boxes, number fields, date pickers, dropdowns and a Future Trip? checkbox. I renamed the button to Add stamp.
  3. Hide it. In the Layers panel I hid the form, so the dashboard opens with just the map.
  4. Connect the passport. On the passport button I set the action to Toggle layer and picked the form as the layer.

Now one click on the passport opens and closes the form so I can add new trips and see the results on the map. The form writes to the same table the dashboard reads from, so nothing else needs to be connected.

Yes, Trulyp can do it too

My Travel Diary started as a Tableau dashboard, and I rebuilt it in Trulyp in one afternoon. Same trips, same travel routes, same passport. What surprised me most is how much simpler it felt: the data, the dashboard and the WriteBackExtreme form all live in one place. I add a new stamp, refresh, and it is on the map.

Have you built something in Tableau and wondered whether it would work in Trulyp? Give it a try! Start with your own trips in an Excel sheet, import it into Trulyp, and go create.

Bon voyage!

← Back to blog