Combining the count of two list items.

Options
harshitha.narayan
edited December 2022 in Modeling

Hi All,

 

So we have a list say Project phase with three list items in it:

 

Project phase>

ALL

- Design

- Implementation

- Done 

 

This is how page selector in dashboard looks like and the data tables also represent the values when we based on the list item we have selected.

 

But now the business has requested to combine two list items and the list should look something like the below one:

 

Project Phase:

- Design + Implementation

- Done

 

This is affecting the data tables and not able to combine the phase.

 

Can someone guide how to combine the result (basically the count of Projects under both the design and Implementation together)

 

Thank you,

harshitha N.

Answers

  • harshitha.narayan@sony.com 

     

    Here is an option on top of my mind you can maybe consider:

    Introduce another level to your list to act as a parent as shown below.

     

    nikmg_0-1671614452612.png

     

    This would enable you to view your aggregates at the L1 level [i.e. design+implementation]. And since L2 level is intact with the original list members/codes, the data mappings are not disturbed. 

    You can now use this L1 List for all your planning activities or use it as context selectors in your pages.

     

    Curious to hear other schools of thought on a more efficient solution.

     

    Best,

    Nik