Skip to main content

I have a 4 table layered structure in my base.  VP<->Objective<->KR<->Project.  Each layer has a link to the layer above/below it.  I am creating an interface to show all of the work under each VP.  For Objectives solely under 1 VP, this is working great.  My challenge is that we have some Objectives that are shared between multiple VPs.  When I show those, I want the table to look like this:

Shared Objective

   Shared KR

        Projects (filtered to show only the selected VPs projects)

I have fields in the Projects table that I can use to filter, but have no way (that I can see) to apply a filter in this way.

I tried creating a link from Project<->VP.  From that, I can build a table of Projects grouped by KR, but I can't show any of the KR information in the table.  Is there a way to do what I am trying?

 

Hey @chriswoodrow,

What interface layout are you using? List?
Would you mind sharing a couple of screenshots of your structure, and of your problem? This will make it way easier for me to help out 😄

Thanks!

Mike, Consultant @ Automatic Nation 

Hey @chriswoodrow,

What interface layout are you using? List?
Would you mind sharing a couple of screenshots of your structure, and of your problem? This will make it way easier for me to help out 😄

Thanks!

Mike, Consultant @ Automatic Nation 


@Mike_AutomaticN - Thank you for your help!

This is an example of the 3 tiers, but showing Projects for all of the teams.

Here is the best I can achieve just showing Projects and grouping by KR.  I show only the Projects for the VP's team, but can't get any details showing for the KR level.

And, yes, I am using a List interface layout.

@Mike_AutomaticN - Thank you for your help!

This is an example of the 3 tiers, but showing Projects for all of the teams.

Here is the best I can achieve just showing Projects and grouping by KR.  I show only the Projects for the VP's team, but can't get any details showing for the KR level.

And, yes, I am using a List interface layout.


Hmm, how does this look?

Data:

 

And it's set up here

Hmm, how does this look?

Data:

 

And it's set up here


That looks nice, but not quite my issue.  Looking at my example, you can see that all VPs (Tom, Sue, and Mary) have a link to "Common Obj A"

In the Projects table, each VP has a Project under "Common Obj A"

My question is, how do I show a List view on the Interface for any given VP that shows "Common Obj A", but only has their Project under it.  For example, for Sue:

ObjectiveKey ResultProject
Obj 2KR 2Proj 2
Common Obj ACommon KR AProj 2A

 

Reply


Terms & Conditions