modified table CountMapTrips= length(rows)flights.geojsonCountries= length(...
M /anton/undefined +0 -0
1---2title: Trips3---4
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/"))))` |5| | Count | Map |6|---|---|---|7| Trips | `= length(rows)` | [flights.geojson](flights.geojson) |8| Countries | `= length(unique(filter(flat(rows.tags), (t) => startswith(t, "country/"))))` | [countries.geojson](countries.geojson) |9| Cities | `= length(unique(filter(flat(rows.tags), (t) => startswith(t, "city/"))))` | [cities.geojson](cities.geojson) |10
11## countries12
13```dataview34 unmodified lines