00ecce6d5f3c74cd710e87c407b673576775b9fe - anton

edit index.md via macOS

− deleted code block TABLE length(rows) AS "Trips", length(unique(filter(flat(row...

+ inserted table CountTrips= length(rows)Countries= length(unique(filter(flat...

1---
2title: Trips
3---
4
5```dataview
6TABLE length(rows) AS "Trips", length(unique(filter(flat(rows.tags), (t) => startswith(t, "country/")))) AS "Countries", length(unique(filter(flat(rows.tags), (t) => startswith(t, "city/")))) AS "Cities"
7WHERE tags
8GROUP BY "total" AS " "
9```
5| | Count |
6|---|---|
7| Trips | `= length(rows)` |
8| Countries | `= length(unique(filter(flat(rows.tags), (t) => startswith(t, "country/"))))` |
9| Cities | `= length(unique(filter(flat(rows.tags), (t) => startswith(t, "city/"))))` |
10
11## countries
12
13```dataview
34 unmodified lines