Help with blocker frequency please!

[Ellejaypea]

My company is using your PowerBI template which has been so helpful for gathering our ADO metrics into an easy to use dashboard. One thing we are a bit confused on at the moment is how the 'blocker frequency' chart should work - is it meant to show a count for every item blocked per day, or just a count for 1 day when an item moves into blocked? The former would be much more useful, but the wiki documentation is a bit ambiguous. I seem to recall it used to work that way but now only shows a count for the day it moves into blocked - any help would be useful, thanks!

[nbrown02]

Hi there,

Thanks for reaching out and your kind words. It's just the initial time it's blocked and not the subsequent days. If I recall (as it has been a while!) I changed this due to performance reasons and users wanting it how it is now.

[Ellejaypea]

Thanks so much for the quick response! How difficult do you think it would be for us to change it to how it used to be (i.e. count of every day things are blocked) - do the performance issues make it not feasible? Would be happy to engage with you as a consultant if its feasible but needs a bit of work - just want to understand the issues.

[nbrown02]

Tbh, I'd need to take a look to remind myself - I don't think it's completely unfeasible it was more I was trying to cut down on usage of snapshot tables. Drop me an email and we can discuss it directly once I've reminded myself on how to do it and then I could give an estimate :)

[Ellejaypea]

Thanks so much - will shoot you an email shortly