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.
1st Shift 2nd Shift 3rd shift
Any and all help would be appreciated.
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:
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:
The 2nd shift:
[2nd Shift].[2nd Shift].GetMemberByKey(
The 3rd shift:
[3rd Shift].[3rd Shift].GetMemberByKey(
These measures allow creating a report like this:
Janis, eazyBI support
@janis.plume - Thank you for this! it worked perfectly. I appreciate it so much!