I’m trying to create a report where I need to show the time (weekly from T-13W to current week) on the X-axis and the Y-axis needs to show the sum of number of unique values that a field called “Implementer” and another field called “Internal Reviewer” assumed during that time interval. Both these fields are of type “User Picker (single user)”.
For example if in week T-12W (12 weeks ago from today), there were 250 issues worked upon and these 250 issues/tickets had the values of “Implementer” field as either “Ashish” or “Drago” or “Priyansu” and the values of “Internal Reviewer” field as either “Vaibahv” or “Andy”, then the Y-axis value for T-12W would be 3+2 = 5.
I’m unable to achieve what is specified above for the Y-axis. Please help.