1---
2title: Trips
3---
4
5## countries
6
7```dataview
8TABLE length(rows) AS "Trips"
9FLATTEN filter(tags, (t) => startswith(t, "country/")) AS country
10WHERE country
11GROUP BY replace(country, "country/", "")
12SORT length(rows) DESC
13```
14
15## countries by year
16
17```dataview
8TABLE length(filter(tags, (t) => startswith(t, "country/"))) AS "Countries", date, purpose WHERE date SORT date DESC GROUP BY dateformat(date, "yyyy")
18TABLE join(unique(map(filter(flat(rows.tags), (t) => startswith(t, "country/")), (t) => replace(t, "country/", ""))), ", ") AS "Countries", length(rows) AS "Trips"
19WHERE date
20SORT date DESC
21GROUP BY dateformat(date, "yyyy")
22```
23
24## cities
25
26```dataview
27TABLE length(rows) AS "Trips"
28FLATTEN filter(tags, (t) => startswith(t, "city/")) AS city
29WHERE city
30GROUP BY replace(city, "city/", "")
31SORT length(rows) DESC
32```
33
34## cities by year
35
36```dataview
37TABLE join(unique(map(filter(flat(rows.tags), (t) => startswith(t, "city/")), (t) => replace(t, "city/", ""))), ", ") AS "Cities", length(rows) AS "Trips"
38WHERE date
39SORT date DESC
40GROUP BY dateformat(date, "yyyy")
41```