In this case, the solution could be a new hierarchy in the “Reporter” dimension to group similar users.
-
You can import additional data on the Reporter from the spreadsheet or some other data source.
The file should contain reporter user names as you see them in eazyBI and another column representing the person name that would match the same person but different users. -
In the data mapping screen, choose a column with a user name as you see it ine azyBI and map it to the “Reporter” dimension, User level. The second column with the person name map to the Reporter dimension, User level, and provide a property name to import it as Reporter property.
Here are more details on additional data import: Additional data import into Jira Issues cube -
When data are imported, you can create a custom hierarchy in the Reporter dimension that would group users by a person’s name.
Here are details on how to create a custom hierarchy: Custom hierarchies -
In the reports, you can use the new hierarchy from the Reporter dimension to group data by role or another property.
The solution is similar to the use case “Issues reported by country” shown in the training video “Power Up Reports With Additional Data Import”.
Here is another Community post on a similar topic how to import additional data on user dimension and create a custom hierarchy on top of that: