The eazyBI data model is built around issues when importing data from Jira.
However, you may enrich the data with additional data import from other data sources using REST API, SQL select, Google Sheets, or files. This way, you may create new Measures and properties, but a creation of new dimensions is not supported.
In your case, you might want to retrieve the project key and count of users for each project role, developer, customer representatives, manager, etc. The additional data might contain one row for each project and the following information:
- project key or name to look up for a project and import additional data. Make sure to mark advanced option Skip missing.
- count of developers, import it as a new measure representing a count of developers for each project
- count of customer representatives, import it as a new ** measure** representing a count of customer representatives for each project
- count of managers, import it as a new ** measure** representing a count of QA users for each project
The data mapping screen might look like in the picture below:
More details on the additional data import and how to map the data are here:
Measures imported this way works well together with dimensions that are mention in the data mapping screen (in your case, Project dimension). If you would like to use other dimensions in the report, then you might want to define a new calculated measure to incorporate measures that are imported from other data sources. For the calculation use function DefaultContext() and a tuple of a measure and dimensions it was mapped to:
More details on calculated measures, tuples, and function DefaultContext() are here:
I would recommend watching a training video on additional data import to get a better understanding of how this works and how imported measures could be used in the reports:
Zane / support@eazyBI.com