In one of my boards, I have a reference column that connects to a new Knowledge Table. The items in the knowledge table are singular and so referencing each entity is perfect to tie multiple tasks on my board to each individual entity.
However, I want to be able to go to my knowledge table and see which tasks are connected to that row, and be able to sort the knowledge table by metadata that lives on the tasks.
To give an example, I have a knowledge table of data sources and a board of projects/tasks that rely on one or more data sources. I want to be able to prioritize which data sources to integrate into my analytics stack based on:
a) the number of tasks connected to each data source (i.e. how many tasks can be completed once this integration exists); and
b) a sum/median/mean of a priority score that is assigned to each task in the board.