Matrix View for relationships

It would be nice if it is possible to have matrix views on Fibery. My use case is the following:

In our company, we define weekly goals that are linked to quarterly goals (same with daily and weekly goals). We now use excel to match them, however, it would be nice if we can do it on Fibery.

For the Weekly vs Quarterly Goals Matrix, we need a clear view of all quarterly goals at a company level, and the possibility to define on this view our weekly goals and mark which ones are related.

My content is in Spanish (I’m from Peru), but I hope the idea is clear.

It sounds like you would be well-suited to define a quarterly goal type, a weekly goal type and a daily goal type and link them in order (one to many) Q → W → D.
I terms of views, you might want to use smart folders maybe with table views at each level, and/or a hierarchical list view.

Sounds great, I haven’t thought about it. I’ll try on a couple of hours. Thanks.

My use case for a matrix view:

I have an Issues DB and a Solutions DB, related many-to-many.

I want to visualize which Solutions are related to which Issues. A matrix is perfect, with each row being an Issue, and each Column being a Solution, allowing me to see where all the relationships are.

Similar to a board view, where the rows are the Issues entities, and the columns are all the Solutions entities, and a “card” is present only where an particular Issue (row) is related to a particular Solution (column).

addition information, Do we have any navigate way to build Report view or Dashboard view like this
image
1 Habit database
1 Periodic database
In 1 matrix view, and can be trigger count by checkbox
Any suggestion for this @Chr1sG , I wanna do some similar things: some criterias for my children, somethings need to track for my employee … It’d be convient for me to see and navigate on an overall view like this

I have split this into a new topic. Will reply fully later.

1 Like

Sure, hoping we have a good solution for this

As you know, there is currently no ‘matrix view’.
The options are:

  • create matrix report:


    Disadvantage: read-only

  • create a helper db and use a board view:


    Disadvantage: not easy to create direct relations
    (possible) Advantage: you can add properties to the helper db, which provides ‘relation attributes’

Long term, there is a small chance that there will be a nice native solution, but I can’t make any promises.

2 Likes

I have consider about kanban way, but like you said, it’s really not convient to view. i thought Report view can create 2 vector (2 kind of databases)?

The first image in my message above shows two databases (A and B) and whether the entities are linked