List specific property values from backlinks, sorted by frequency

What I’m trying to do

I have author and book notes, and link to the authors from the “broader” list property of my book notes. The books also have a “genres” list property. I have a base that lists authors, and it would be nice if I could list the genres in another column of that table, in order of frequency that they are mentioned in the “genres” property of the author’s books.

Things I have tried

Searched on the forum and the web.

Just to understand you idea. You want that your bases list the genres of each author based on the genre property of book notes which are linked to the respective author?

So something like this:

Indeed! And sorted in order of frequency that they appear on the books.

For the sorting part I have no idea. According to Obsidian help, the sort() function can only sort by numbers or alphabetically.

1 Like

I don’t know if it’s possible to create like a separate hidden column, where the genres are counted, and then order them by that number in the final output?

I think this would not solve the issue. You would still require a function that sorts the list.

You can have a look at feature requests. If there is request towards a more advanced sort function, you can request it yourself.

1 Like

Thanks!