nbrown02 / FlowViz

A Power BI template that provides easy to understand, actionable flow metrics and predictive analytics for your agile teams using Azure DevOps, Azure DevOps Server and/or TFS.
https://flowviz.thinkific.com/courses/fundamentals
MIT License
202 stars 47 forks source link

WIP and Cycle Time page - The team slicer does not filter correctly. #138

Closed MiguelSilva-PBSS closed 1 month ago

MiguelSilva-PBSS commented 1 month ago

Hello,

We have a team project with many teams.

On the WIP page, we select/filter a specific team using the "Team" slicer, but the graphs and pop-up show also show data (work items) from other teams.

For example, I selected/filtered the "AA" team, but the "Work item Age" and "Daily Work in Progress (WIP)" charts also show data from the "CC" team.

Wasn't it supposed to only present data from the selected/filtered "AA" team?

Note: The Area Path is common to both teams.

Best regards.

Desktop (please complete the following information):

nbrown02 commented 1 month ago

Hey Miguel - thanks for pointing this out. Sounds like a bug, I'll need to triage it and see how I can fix :)

MiguelSilva-PBSS commented 1 month ago

I just noticed that this problem also happens on the cycle time page. Thank you for your attention.

nbrown02 commented 1 month ago

If an item appears on both teams boards by nature of a shared area path then it should be displayed on cycle time for both teams. So this is the expected behaviour.

MiguelSilva-PBSS commented 1 month ago

In Azure Devops, items don't appear on both teams' boards. Teams can share the same area path, but the iteration path cannot.

In the "Team Configuration" settings in Azure Devops, teams can share the same area path, but have created different iteration paths. Because of this, items do not appear at the same time in both boards.

However, I understood what you said!

Another problem I found when filtering by team, more specifically in column charts.

The “AA” team created the “Validation” column, but the “CC” team didn't create this column.

The area path is the same for both teams.

On the WIP page, when filtering by "CC" team, in the "Daily Work in Progress (WIP)" graph, the "Validation" column appears, but this team does not have this column on its board!

Thanks.

nbrown02 commented 1 month ago

Could you send me / email me your setup? I want to try mimic it in a test area to replicate what you are seeing.

Part of the challenge is I work on this just myself and nowhere near the scale other orgs will use it!

On Thu, Sep 12, 2024 at 10:10 AM Miguel Silva @.***> wrote:

In Azure Devops, items don't appear on both teams' boards. Teams can share the same area path, but the iteration path cannot.

In the "Team Configuration" settings in Azure Devops, teams can share the same area path, but have created different iteration paths. Because of this, items do not appear at the same time in both boards.

However, I understood what you said!

Another problem I found when filtering by team, more specifically in column charts.

The “AA” team created the “Validation” column, but the “CC” team didn't create this column.

The area path is the same for both teams.

On the WIP page, when filtering by "CC" team, in the "Daily Work in Progress (WIP)" graph, the "Validation" column appears, but this team does not have this column on its board!

Thanks.

— Reply to this email directly, view it on GitHub https://github.com/nbrown02/FlowViz/issues/138#issuecomment-2345705713, or unsubscribe https://github.com/notifications/unsubscribe-auth/AHACM2VS5E33IFQBN3JWXILZWFLAHAVCNFSM6AAAAABN63ILDWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDGNBVG4YDKNZRGM . You are receiving this because you commented.Message ID: @.***>

MiguelSilva-PBSS commented 1 month ago

I will share with you the settings I use in the company, so that you can simulate my problems:

Important: All the configurations that I will share are to be done in the same team project!

1- Create two teams: 1.1 - AA 1.2 - CC

  1. Create the following areas path:
  1. Associate ABC_Product with the two teams with the sub-areas included;

  2. Create the follwing iterations 4.1 AA_Iterations (parent) Sprint01 (child) Sprint02 (child)

    4.2 CC_Iterations (parent) Sprint01 (child) Sprint02 (child)

  3. Associate these iterations with the respective team; AA -> AA_Iterations\Sprint01 AA -> AA_Iterations\Sprint02

    CC -> CC_Iterations\Sprint01 CC -> CC_Iterations\Sprint02

  4. Configure the following columns on team border: 7.1 Team AA: New Approved Committed Done 7.1 Team CC New Approved Committed Validation Done

  5. Finally, create the work items with the following characteristics:

    8.1 Team AA:

      Work item - Test AA.1
          Area Path: ABC_Product
          Iteration: AA_Iterations\Sprint01
          Column Board: Approved
    
      Work item - Test AA.2
          Area Path: ABC_Product\Sales
          Iteration: AA_Iterations\Sprint01
          Column Board: Committed

    8.2 Team CC:

      Work item - Test CC.1
          Area Path: ABC_Product
          Iteration: CC\Sprint01
          Column Board: Validation
    
      Work item - Test CC2
          Area Path: ABC_Product\Accounting\Documents
          Iteration: CC_Iterations\Sprint01
          Column Board: Committed

Thank you for your attention.

nbrown02 commented 1 month ago

Should now be fixed if you want to give it a retest...

MiguelSilva-PBSS commented 1 month ago

I will retest. I need to download it again, right?

nbrown02 commented 1 month ago

Yup that’s correct :)Sent from my iPhoneOn 16 Sep 2024, at 18:27, Miguel Silva @.***> wrote: I will retest. I need to download it again, right?

—Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you commented.Message ID: @.***>

MiguelSilva-PBSS commented 1 month ago

Hi,

I did some tests on the various pages, but I think the problem is not 100% resolved yet.

On the “WIP” page it is resolved, but on the “Dashboard” and “Cycle Time” pages it isn't resolved.

For example,
on the "Dashboard" page, if we do "Drill through" (page D1), the work items of the "CC" team will appear in the list, but I only selected the "AA" team. So, I don't know if the error is just in the "D1" tooltip or if the chart is also including data from other teams. In the "Quality (bug rate)" chart, the same thing also happens when we do "Drill through" ("page D2").

On the "Cycle time" page, the "Cycle time scatterplot" and "Lead time scatterplot" graphs continue to display work items from other teams when I filter just one team. Also on this page, the "Avegare Cycle Time per Week by Work Item" chart lists work items from other teams when we "Drill through" ("page D3").

I didn't get to test the "Average Lead Time Per Weel by Work Item" chart.

Thanks for your effort and attention.

nbrown02 commented 1 month ago

Hmm strange. Is that using the same setup? Just wondering what I can to mimic it my end...

On Tue, Sep 17, 2024 at 3:09 PM Miguel Silva @.***> wrote:

Hi,

I did some tests on the various pages, but I think the problem is not 100% resolved yet.

On the “WIP” page it is resolved, but on the “Dashboard” and “Cycle Time” pages it isn't resolved.

For example, on the "Dashboard" page, if we do "Drill through" (page D1), the work items of the "CC" team will appear in the list, but I only selected the "AA" team. So, I don't know if the error is just in the "D1" tooltip or if the chart is also including data from other teams. In the "Quality (bug rate)" chart, the same thing also happens when we do "Drill through" ("page D2").

On the "Cycle time" page, the "Cycle time scatterplot" and "Lead time scatterplot" graphs continue to display work items from other teams when I filter just one team. Also on this page, the "Avegare Cycle Time per Week by Work Item" chart lists work items from other teams when we "Drill through" ("page D3").

I didn't get to test the "Average Lead Time Per Weel by Work Item" chart.

Thanks for your effort and attention.

— Reply to this email directly, view it on GitHub https://github.com/nbrown02/FlowViz/issues/138#issuecomment-2355944691, or unsubscribe https://github.com/notifications/unsubscribe-auth/AHACM2SUBLSNGCSRKHXDOYTZXAZYBAVCNFSM6AAAAABN63ILDWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDGNJVHE2DINRZGE . You are receiving this because you commented.Message ID: @.***>

MiguelSilva-PBSS commented 1 month ago

I downloaded the FlowViz (Project).pbit file again, configured the company and team project.

Check, for example, on the "Cycle Time" page, the "Cycle Time Scatterplot" and the "Delivery Time Scatterplot". The problem continues.

You can also check the D2 tooltip.

nbrown02 commented 1 month ago

Thanks - I am going to take a proper look at it this week to fix :)

On Thu, Sep 19, 2024 at 3:28 PM Miguel Silva @.***> wrote:

I downloaded the FlowViz (Project).pbit file again, configured the company and team project.

Check, for example, on the "Cycle Time" page, the "Cycle Time Scatterplot" and the "Delivery Time Scatterplot". The problem continues.

You can also check the D2 tooltip.

— Reply to this email directly, view it on GitHub https://github.com/nbrown02/FlowViz/issues/138#issuecomment-2361156022, or unsubscribe https://github.com/notifications/unsubscribe-auth/AHACM2UTNJIOAS25KJH65WDZXLNRZAVCNFSM6AAAAABN63ILDWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDGNRRGE2TMMBSGI . You are receiving this because you commented.Message ID: @.***>

MiguelSilva-PBSS commented 1 month ago

Hi,

Did you fix the issue? I'm available to validate again!

nbrown02 commented 1 month ago

Unfortunately not, time got away from me this week. I will have time on Monday!

On Fri, Oct 4, 2024 at 2:46 PM Miguel Silva @.***> wrote:

Hi,

Did you fix the issue? I'm available to validate again!

— Reply to this email directly, view it on GitHub https://github.com/nbrown02/FlowViz/issues/138#issuecomment-2393746600, or unsubscribe https://github.com/notifications/unsubscribe-auth/AHACM2XAN3AQ5SJMISEX7VLZZ2L37AVCNFSM6AAAAABN63ILDWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDGOJTG42DMNRQGA . You are receiving this because you commented.Message ID: @.***>

nbrown02 commented 1 month ago

This is fixed now :)

MiguelSilva-PBSS commented 4 weeks ago

Hello,

I confirm that on the "Cycle Time" page the issue is resolved.

However, the problem continues on the "Dashboard" page. As I mentioned before, on this page if we do "Drill through" (page D1), the work items of the "CC" team will appear in the list, but I only selected the "AA" team. So, I don't know if the error is just in the "D1" tooltip or if the chart is also including data from other teams. In the "Quality (bug rate)" chart, the same thing also happens when we do "Drill through" ("page D2").

Would you prefer I create a new issue referenced only on this page?

nbrown02 commented 4 weeks ago

@MiguelSilva-PBSS - try the latest version (just published another one) and see if still exists then please open a new issue if it does :)

MiguelSilva-PBSS commented 4 weeks ago

This issue was resolved, but unfortunately another one appeared.

When I filter a team, bugs are not considered, but only when a team has the "bugs are managed with tasks" configuration. I will create a new issue, with more details so you can simulate it.

Thanks.

nbrown02 commented 4 weeks ago

As per #139 - no plans to fix this due to effort vs. value a fix would bring.