How to get the total number of bugs assigned to a specific person as of yesterday

Questions & Answers
1

Hi, everyone!
I am using eazyBI to track the status of bug handling for each developer in a team. I made “Assignee” as row and set a fix name list, then I set some columns to get different data. A sample rule is that, for a developer, I want to know the total number of bugs assigned to him as of today, as well as the total number of bugs assigned to him as of yesterday, in this way I can determine whether the number of bugs assigned to him is increasing or decreasing in a daily view.
But I really can’t find a way to count the total number of bugs assigned to the developer as of yesterday.
Here is my report:

image
image660×238 4.61 KB

I’m hoping that someone can help me solve this problem,Thanks~~

2

Hi EngineerBy,
Welcome to the eazyBI community!

You can find the number of bugs assigned at the end of yesterday you can use the predefined measure “Issues history” in the following formula:

([Measures].[Issues history], -- balance-type measure
[Issue type].[Bug], -- only bug issue type
[Time].[Day].CurrentDateMember.PrevMember) -- at the end of yesterday

If you want at the beginning of yesterday, then use Time member:
[Time].[Day].DateMember('2 days ago'))

Let me know if that works for you or if you need some adjustments.

Kindly,
Ilze

3

Hi, so many thanks, it really works :smiley:

1 Like