# Matrix View for relationships **URL:** \ **Category:** Ideas & Features\ **Created:** [October 6, 2021, 3:54am UTC](https://community.fibery.io/t/matrix-view-for-relationships/2102 "2021-10-06T03:54:09Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![DioniGR27](https://avatars.discourse-cdn.com/v4/letter/d/e495f1/32.png) [@DioniGR27](https://community.fibery.io/u/DioniGR27)\ **Post date:** [October 6, 2021, 3:54am UTC](https://community.fibery.io/t/matrix-view-for-relationships/2102/1 "2021-10-06T03:54:09Z")
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. ![Fibery](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/9/96fd99ef13f28c5c894d2ec49740a6e1e2cb05b9.png) My content is in Spanish (I’m from Peru), but I hope the idea is clear. ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [October 6, 2021, 11:26am UTC](https://community.fibery.io/t/matrix-view-for-relationships/2102/2 "2021-10-06T11:26:48Z")
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. ---
**Author:** ![DioniGR27](https://avatars.discourse-cdn.com/v4/letter/d/e495f1/32.png) [@DioniGR27](https://community.fibery.io/u/DioniGR27)\ **Post date:** [October 6, 2021, 1:48pm UTC](https://community.fibery.io/t/matrix-view-for-relationships/2102/3 "2021-10-06T13:48:17Z")
Sounds great, I haven’t thought about it. I’ll try on a couple of hours. Thanks. ---
**Author:** ![Matt\_Blais](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/matt_blais/32/1464_2.png) [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\ **Post date:** [January 15, 2022, 9:30pm UTC](https://community.fibery.io/t/matrix-view-for-relationships/2102/4 "2022-01-15T21:30:53Z")
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). ---
**Author:** ![Minh\_Tri\_Do\_Hang](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/minh_tri_do_hang/32/6791_2.png) [@Minh\_Tri\_Do\_Hang](https://community.fibery.io/u/Minh_Tri_Do_Hang)\ **Post date:** [August 2, 2023, 2:46am UTC](https://community.fibery.io/t/matrix-view-for-relationships/2102/5 "2023-08-02T02:46:44Z")
addition information, Do we have any navigate way to build Report view or Dashboard view like this ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/2/23c2fc5509c1ee1f2373493a13a5b5d215b3d32c.jpeg) 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 ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [August 2, 2023, 9:57am UTC](https://community.fibery.io/t/matrix-view-for-relationships/2102/6 "2023-08-02T09:57:33Z")
I have split this into a new topic. Will reply fully later. ---
**Author:** ![Minh\_Tri\_Do\_Hang](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/minh_tri_do_hang/32/6791_2.png) [@Minh\_Tri\_Do\_Hang](https://community.fibery.io/u/Minh_Tri_Do_Hang)\ **Post date:** [August 3, 2023, 4:28am UTC](https://community.fibery.io/t/matrix-view-for-relationships/2102/7 "2023-08-03T04:28:27Z")
Sure, hoping we have a good solution for this ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [August 3, 2023, 9:11am UTC](https://community.fibery.io/t/matrix-view-for-relationships/2102/8 "2023-08-03T09:11:27Z")
As you know, there is currently no ‘matrix view’. The options are: - create matrix report: - create a helper db and use a board view: Long term, there is a small chance that there will be a nice native solution, but I can’t make any promises. ---
**Author:** ![Minh\_Tri\_Do\_Hang](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/minh_tri_do_hang/32/6791_2.png) [@Minh\_Tri\_Do\_Hang](https://community.fibery.io/u/Minh_Tri_Do_Hang)\ **Post date:** [August 3, 2023, 9:50am UTC](https://community.fibery.io/t/matrix-view-for-relationships/2102/9 "2023-08-03T09:50:51Z")
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)? ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [August 3, 2023, 10:09am UTC](https://community.fibery.io/t/matrix-view-for-relationships/2102/10 "2023-08-03T10:09:55Z")
> [@Minh\_Tri\_Do\_Hang](#): > > 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