Thank you so much for your help and for explaining the functions, the all chapters query is super helpful too. Thank you also to @Guapa for the explanation.
I do have a question about it, though. As you can see below it lists every instance of the event appearing in the list. Is there a way to just have the name of the event listed once with a count of how many times it’s appeared next to it (e.g. Austerlitz Campaign (3)) instead? I looked at the documentation again and saw some functions in there, but I don’t know how to use them so I don’t know if they would help.
Also, I’ve noticed that some of the files are listed in reverse number order or just incorrect order - is this something I can fix by adding a line to the query too or is this just a thing that happens? This happens in:
-
The ‘all character appearances’ section: events are in reverse number order. I tried adding ‘sort rows.file.link asc’ to force the chapter row to sort by ascending, but this seems to have made it sort from least chapters in a row to most chapters in a row (so basically character with least appearances to character with the most appearances).
-
Also, the chapters column in the character appearances tables (both in the all chapters section and in both of the event sections) will sometimes randomly be out of order regardless of how it’s trying to sort the chapters. This does go away if I close and reopen Obsidian until it sorts right, is this just a thing that happens sometimes?
