The note below is for a film that has been viewed three times in three different locations by the same three people.
The # Full Listing
Dataview table creates a summary of the metadata, detailing when, where, and how the film was watched and the scores out of ten that each person gave for each viewing. If they didn’t attend a viewing, the score is listed as "NA"
.
In the second # Tokyo Only
Dataview table, I would like to extract just the data relating to Tokyo: date, how, and scores.
Using FLATTEN WhereWatched
, I can see Tokyo as the only city listed, but I still have the data for all the dates and viewings.
I have tried lots of different ideas, all without success.
Is it possible to extract just the data (entire row) relevant to the viewing in Tokyo?
# Title:: More Banshees of Inisherin (2023)
[](https://www.imdb.com/title/tt11813216)
***
> [!note]- ### More Banshees of Inisherin (2023) | [IMDb](https://www.imdb.com/title/tt11813216)
> **Aka**:: Where Have All the Fingers Gone?
> **Year**:: [[2022]]
> **Runtime**:: 114 min
> **Directors**:: [[Martin McDonagh]]
> **Writers**:: [[Martin McDonagh]]
> **Actors**:: [[Colin Farrell]], [[Brendan Gleeson]], [[Kerry Condon]]
> **Country**:: [[Ireland]], [[United Kingdom]], [[United States]]
> **City**:: [[Banshee City]]
> **IMDb**:: [IMDb](https://www.imdb.com/title/tt11813216)
> **IMDbRating**:: 8.0
> **Poster**:: https://m.media-amazon.com/images/M/MV5BM2NlZDI0ZDktNTg5OS00ZjQ1LWI4MDEtN2I0MDE5NWRiNzA4XkEyXkFqcGdeQXVyMTY5Nzc4MDY@._V1_SX300.jpg
> **Genre**:: [[Comedy]], [[Drama]]
> **WhenWatched**:: [[2023-01-13-Friday]], [[2022-12-26-Monday]], [[2021-12-31-Friday]]
> **WhereWatched**:: [[New York]], [[London]], [[Tokyo]]
> **HowWatched**:: [[Cinema]], [[Apple TV]], [[Private screening]]
> **PersonA**:: 7, 8, 7
> **PersonB**:: 10, "NA", 9
> **PersonC**:: "NA", "NA", 6
> **Tags**:: #fictionalfilms
# Full Listing
```dataview
TABLE WITHOUT ID
choice(typeof(WhenWatched) = "array", WhenWatched, list(WhenWatched)) AS When,
choice(typeof(WhereWatched) = "array", WhereWatched, list(WhereWatched)) AS Where,
choice(typeof(HowWatched) = "array", HowWatched, list(HowWatched)) AS How,
choice(typeof(PersonA) = "array", PersonA, list(PersonA)) AS PersonA,
choice(typeof(PersonB) = "array", PersonB, list(PersonB)) AS PersonB,
choice(typeof(PersonC) = "array", PersonC, list(PersonC)) AS PersonC
FROM
#fictionalfilms
SORT
max(WhenWatched.file.day)
DESC
```
# Tokyo Only
```dataview
TABLE WITHOUT ID
choice(typeof(WhenWatched) = "array", WhenWatched, list(WhenWatched)) AS When,
choice(typeof(WhereWatched) = "array", WhereWatched, list(WhereWatched)) AS Where,
choice(typeof(HowWatched) = "array", HowWatched, list(HowWatched)) AS How,
choice(typeof(PersonA) = "array", PersonA, list(EPM)) AS PersonA,
choice(typeof(PersonB) = "array", PersonB, list(KLM)) AS PersonB,
choice(typeof(PersonC) = "array", PersonC, list(BCM)) AS PersonC
FROM
#fictionalfilms
FLATTEN
WhereWatched
WHERE
contains(WhereWatched, [[Tokyo]])
SORT
max(WhenWatched.file.day)
DESC
```
Thanks in advance for any pointers or solutions.