Dataview - Table that Counts the Number of Times a Character(Note) Appears in an Inline Field

I am new to Dataview and having an issue. I’m using Obsidian to track character appearances in a story, and I want to know how many times they appear and whether they have a major or minor influence on the story.

The episode notes would be structured like this. The character’s names either have a major or minor involvement in the story.

This is how I’d like the table to appear.

Additional Information

  • The notes will have the tag #episode for each major and minor appearance.
  • Have a list of character’s profiles that are under the tag #character

Have tried various iterations of code, but it doesn’t come close to what I want.

table length(rows.major)
FROM #Episode 
Where major
GROUP BY major

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.