User statistic in the sprint. Including sub-tasks. Filtering by label

Questions & Answers
1

Hi.
I need to create a eazyBI report where it should show user statistic in the sprint

  1. Total SP in the sprint done by user. Including all subtasks assigned to a user (All tasks in the sprint basically)
  2. Total Number of tasks assigned on user in the sprint. Including all subtasks assigned to a user (All tasks in the sprint basically)
  3. Total SP in the all subtasks assigned to a user in Stories with label “B”
  4. Total Number of tasks assigned on user in Stories with label “B”
User      |Number of SP |Number of Tasks |Number of 'B' SP |Number of 'B' tasks
User 1    |20           | 10             |  6              | 10
User 2    |18           | 8              |  5              | 9
...

Please advise on this.

Thanks

2

Hi Maxim,

A few clarifying questions:

(1) “Total SP in the sprint done by user” - what is meant by “done by user”? Should these be SP resolved by the user? Or SP assigned to the user?

(2) Do you assign StoryPoints to Stories and also to their Sub-tasks? Or only to the Sub-tasks and not to the Stories?

Kindly,
Ilze