Summary in a hierarchical list

soukainawaraki
soukainawaraki
in Integrations and extensibility

Hi all,

 

I have a module that returns the number of people per project, with a hierarchical list in the dimension.
In the "summary" I have the sum of the people who worked per iteration each time : 

For example: 

Iteration 1 = 1 person
Iteration 2 = 1 person

Sum of project 1 = 2 people while it's the same person. I can't fix it. I wish to have in short only 1 person, the one who worked.

 

Do you know how I can fix this?

 

Regards,

Tagged:

Answers

  • einas.ibrahim
    einas.ibrahim

    Hi @soukainawaraki 

    If you provide a screenshot or any sort of visual presentation, it'll help us better understand the issue.

     

    However, based on what you said, I suggest checking the ISFIRSTOCCURANCE() function. It'll allow you to only count a person once when (s)he appears for the first time and ignore all subsequent appearances.

  • Misbah
    Misbah

    @soukainawaraki 

     

    You may want to change the Summary of the line item to Min, Max or Average. I believe if every leaf item is having 1 headcount you can use these options to get 1 at the Summary level.

     

    If that doesn't help please post screenshot of your module so that we can help better

     

    Misbah

  • soukainawaraki
    soukainawaraki

    Hello, 

     

    On this view, I have 3 people on sprint 1 for example etc.

     

    The sum in "summary" returns me 35 but I don't have 35 people. I have the same people working on sprints, I only want the number of people who have worked. I hope I'm clear on this... 

     

    soukainawaraki_0-1597319918345.png

     

    Regards,

  • einas.ibrahim
    einas.ibrahim

    That’s why you use something like ISFIRSTOCCURANCE() to eliminate duplicates. 

  • Misbah
    Misbah

    @soukainawaraki 

     

    What do you want to see in the totals? If it is 3 then use MIN if 4 then use MAX in summary settings in blueprint mode.

     

    Misbah

Categories