Hi Community,
We would need help to generate a report that compares whether the assignee is different from a user defined in a custom field and we cannot find how to resolve it.
Thanks in advance
Hi, @adgonzalez
Welcom to the community.
First, please import your custom field into eazyBI.
The solution changes depending on whether you want to see the data based on Issues, Assignee, etc.
The first example, based on the issues:
- Select the Issues dimension in the rows
- Select two properties: Issue Assignee and Issue
- Add the new calculates measure using this formula:
IIF(
[Measures].[Issue assignee] MATCHES
[Measures].[Issue Custom User Picker],
1,
0)
And the report will look something like this:
Another example:
- Select the Assignee dimension in the rows
- Select the measure “Issues created” in the rows
- Add dimension “” into the rows.
The report should look something like this:
Kindly,
Ilze