Count number of work shifts a person has worked

Questions & Answers
1

Hi i need some help on where to start with this. On my jira tickets, i have three shifts that I can put user names in (track who does what shift). I have three people per shift, for a total of nine people. I want to be able to create just one table that lists each person once, then the shift with the number of times they show up in that shift. These are custom fields.

For example:

                 1st Shift           2nd Shift        3rd shift

Jon Smith

Jane Doe

Etc.

Any and all help would be appreciated.

2

Hi,

Please find here a solution, assuming that you use three User picker fields to select the user in shift.
It is also assumed that all users should be present for some shift (e.g., all users should be at some point in shift 1).

I imported all the custom fields as dimensions:

image
image1388×406 22.7 KB

Now I can put the 1st Shift dimension in the report rows and create custom formulas for counting how many issues are with the user in each shift.

The 1st shift:

[Measures].[Issues created]

The 2nd shift:

([Measures].[Issues created],
[2nd Shift].[2nd Shift].GetMemberByKey(
  [1st Shift].CurrentMember.KEY
),
[1st Shift].DefaultMember
)

The 3rd shift:

([Measures].[Issues created],
[3rd Shift].[3rd Shift].GetMemberByKey(
  [1st Shift].CurrentMember.KEY
),
[1st Shift].DefaultMember
)

These measures allow creating a report like this:

image
image1498×742 65.9 KB

Kindly,
Janis, eazyBI support

3

@janis.plume - Thank you for this! it worked perfectly. I appreciate it so much!