Number of Days Blocked Count incorrect

[jenniferrosemitchell21]

Number of Days Blocked Count incorrect

[nbrown02]

@jenniferrosemitchell21 can you give this a retest for me?

[jenniferrosemitchell21]

@nbrown02
This is what I'm getting :

[nbrown02]

Ah ok - let me play around with it and try again…Sent from my iPhoneOn 26 Oct 2023, at 14:32, jenniferrosemitchell21 ***@***.***> wrote: @nbrown02 This is what I'm getting : —Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you were mentioned.Message ID: ***@***.***>

[nbrown02]

@jenniferrosemitchell21 can you try again?

[jenniferrosemitchell21]

@nbrown02
Not had a chance to validate yet, but instantly looks better :

[nbrown02]

Perfect - when you have time to fully check let me know - I can see the sorting needs fixing also :) Sent from my iPhoneOn 26 Oct 2023, at 15:06, jenniferrosemitchell21 ***@***.***> wrote: @nbrown02 Not had a chance to validate yet, but instantly looks better : —Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you were mentioned.Message ID: ***@***.***>

[jenniferrosemitchell21]

@nbrown02
Hi Nick,
See screenshots. Not matching so far unfortunately

[nbrown02]

How are those items being blocked? That looks like a custom field maybe?Sent from my iPhoneOn 26 Oct 2023, at 15:50, jenniferrosemitchell21 ***@***.***> wrote: @nbrown02 Hi Nick, See screenshots. Not matching so far unfortunately —Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you were mentioned.Message ID: ***@***.***>

[jenniferrosemitchell21]

Hi Nick, Standard Blocked field utilised across all Projects

[nbrown02]

For thar particular work item, can you share screenshots of what the table view looks like in ADO? Specifically for the NumberOfBlockedDaysTotal column

[jenniferrosemitchell21]

@nbrown02 Hi Nick, I'm unsure which ADO table you mean?

[nbrown02]

Can you try the latest version @jenniferrosemitchell21 ?

[jenniferrosemitchell21]

Hi @nbrown02 , A few strange things going on. See table below, some are correct but majorly are incorrect. Checked this with 2 ADO Projects - can send over more data if you need it ?

<style> </style>

ID	Blocked 'Yes' Date	FlowViz # of days blocked	Currently blocked
101941	26-Oct	9	no
105659	23-Oct	5	no
107065	17-Nov	3	yes
107599	20-Oct	4	no

[nbrown02]

I think I'll just leave it - for the value it adds and the effort already spent on it (plus a lack of decent test data to work with my end) it's not going to be worth fixing...

[jenniferrosemitchell21]

@nbrown02 OK, understand. Will you be reverting the template to the prior version (where blocked was measured from Change Date?). I am working with another new Team now and would like to get them setup with this version of your dashboard (they dont yet have any power automate flows setup, so change date should suffice for them)

[nbrown02]

Yeah will do, finding the time might be a challenge though!Sent from my iPhoneOn 21 Nov 2023, at 14:15, jenniferrosemitchell21 ***@***.***> wrote: @nbrown02 OK, understand. Will you be reverting the template to the prior version (where blocked was measured from Change Date?). I am working with another new Team now and would like to get them setup with this version of your dashboard (they dont yet have any power automate flows setup, so change date should suffice for them) —Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you were mentioned.Message ID: ***@***.***>

[nbrown02]

Reverted back now @jenniferrosemitchell21 - closing this issue.

Won't fix due to test data limitations - documentation updated